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.
Shopify E-commerce Site Development Category: ECommerce, HTML, SEO, Shopify, Shopify Development, Web Design, Web Development Budget: ₹1500 - ₹12500 INR
11-Apr-2026 16:04 GMT
Research & Create Sellable Canva Products Category: Canva, Competitor Analysis, Content Creation, Digital Marketing, Digital Product Design, Graphic Design, Keyword Research, Market Research Budget: $2 - $8 USD
11-Apr-2026 16:04 GMT
Residential Structural Analysis Required Category: Architectural Engineering, AutoCAD, Building Architecture, Building Design, Building Engineering, Civil Engineering, Design Optimization, Drafting, Revit, Structural Engineering Budget: $30 - $250 USD
Supply Chain Logistics Platform Build Category: Android, AngularJS, API Development, Cloud Computing, Microservices, Mobile App Development, NoSQL Couch & Mongo, Web Development Budget: ₹12500 - ₹37500 INR
11-Apr-2026 16:00 GMT
QA Tester Needed for Web Application Category: Regression Testing, Software Testing, Test Automation, Test Plan Writing, Test Strategy Writing, Testing / QA, Web Application, Website Testing Budget: $2 - $8 USD
11-Apr-2026 16:00 GMT
Modern Agricultural Landscape Design Plan Category: 2D Drafting, 3D Modelling, 3D Rendering, AutoCAD, Interior Design, Landscape Design, Project Management, SketchUp Budget: €30 - €250 EUR
11-Apr-2026 15:59 GMT
CodeIgniter & PHP Upgrade Fix Category: Cloud Computing, Git, HTML, MySQL, PHP, Web Application, Web Development, Web Design Budget: €30 - €250 EUR
Bangun Toko Online Shopify -- 2 Category: Data Entry, ECommerce, Shopify, Shopify Development, Shopify Templates, Web Development, Web Search, Web Design Budget: $15 - $25 USD
11-Apr-2026 15:57 GMT
Story Book Writing For Kids 2 Category: Book Writing, Content Writing, Creative Writing, EBooks, Editing, Fiction, Ghostwriting, Proofreading, Publishing Budget: $250 - $750 USD
11-Apr-2026 15:56 GMT
Manus Site WordPress Migration Category: Content Management System (CMS), CSS, HTML, PHP, SEO, Web Development, WordPress Budget: $250 - $750 USD
11-Apr-2026 15:53 GMT
2km Arma Frontline Map Category: 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, Cartography & Maps, Game Design, Game Development, Illustration Budget: €250 - €750 EUR
11-Apr-2026 15:53 GMT
Engaging Social Media Graphics Category: Adobe Illustrator, Photoshop, Banner Design, Canva, Graphic Design, Illustration, Social Media Marketing Budget: $15 - $25 USD
