I have a google sheet that I would like to generate a price based on different information on different tabs. I have uploaded an excel version of the sheet but the code needs to work in Google Sheets as this is the format of the live version.
There are sizes (column AJ and AK) to work out a square meter size. The minimum chargeable size is 0.3sqm so anything under this size needs to be charged at 0.3 minimum. Column H contains a product code of either "DGU" or "Single".
If DGU is selected then the input information is in columns AL:AQ using the corresponding prices on tab "sealed unit pricing".
If "Single" is selected then the input information is in Columns AR:AT using the corresponding prices on tab "Single sheet pricing".
Finally the line item total calculated from the above would be multiplied by the quantity in column J with the final price input into the column K.
Kitchen Extension Plans Category: Architecture, AutoCAD, Building Architecture, Building Design, Building Engineering, Building Regulations, CAD / CAM, Construction, Home Design, Interior Design Budget: $3000 - $5000 AUD
16-Feb-2026 22:57 GMT
Stick Figure Animation for Education Category: 2D Animation, 3D Animation, Adobe Animate, Adobe Flash, After Effects, Animated Video Development, Animation, Graphic Design Budget: ₹600 - ₹1500 INR
16-Feb-2026 22:57 GMT
Documentary Editors for YouTube Channel Category: 3D Animation, Adobe Premiere Pro, After Effects, Animation, Data Visualization, Motion Graphics, Video Editing, Video Post Editing, Video Production, YouTube Video Editing Budget: ₹12500 - ₹37500 INR
16-Feb-2026 22:56 GMT
Cybersecurity Breach Investigation Category: Computer Security, Digital Forensics, Internet Security, Network Security, Penetration Testing, Risk Assessment, Technical Writing, Web Security Budget: $250 - $750 CAD
16-Feb-2026 22:56 GMT
Experienced Online Bidding Assistant Category: Google Adwords, Internet Marketing, Sales, SEO, Shopify, Virtual Assistant, Web Development, WordPress Budget: ₹100 - ₹400 INR
16-Feb-2026 22:55 GMT
Revamp Knowledge Base with AI Category: AI Chatbot Development, AI Content Editing, Article Rewriting, Article Writing, Content Writing, Copywriting, Editing, Technical Writing Budget: $2 - $8 CAD
16-Feb-2026 22:54 GMT
Freelancer Balas Chat WhatsApp Category: Customer Service, Customer Support, Indonesian Translator, Time Management, Translation, Virtual Assistant Budget: min $50 USD
16-Feb-2026 22:53 GMT
Realistic Game UI Artist Needed Category: 2D Animation, 2D Drawing, 2D Game Art, Game Design, Game Development, Game UI, Graphic Design, Mobile App Development, UI / User Interface Budget: $2 - $30 USD
16-Feb-2026 22:52 GMT
Indonesian to English Translation (Lifestyle/Business) Category: Editing, English (US) Translator, English Grammar, English Translation, Indonesian Translator, Language Tutoring, Proofreading, Translation Budget: $15 - $25 USD
Clothing E-commerce Site Development Category: Content Management System (CMS), Digital Marketing, ECommerce, Inventory Management, Mobile App Development, Payment Gateway Integration, Social Media Marketing, Web Development, Web Security, Web Design Budget: $250 - $750 USD