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.
Operations Systems Architect for Multifamily Property Category: Airtable, Asana, Business Analysis, Business Plans, ClickUp, Excel, Monday.com, Notion, Operations Management, Project Management Budget: $1500 - $3000 USD
14-May-2026 15:59 GMT
Tech & Business Content Writer Category: Article Writing, Blog Writing, Content Writing, Copywriting, Keyword Research, SEO, Social Media Marketing, Technical Writing Budget: $30 - $250 USD
14-May-2026 15:58 GMT
PHP Database Refactor With AI Tagging Category: AI Content Creation, AI Development, AI Model Development, AI Text To Text, Database Design, Database Management, HTML, MySQL, PHP, Software Architecture Budget: $30 - $250 USD
Insert 909 Photos into Excel Category: Data Entry, Data Processing, Excel, Excel Macros, Excel VBA, Image Processing, Microsoft Office, PDF Budget: $10 - $30 USD
Urgent 3D Product Prototype Category: 3D Animation, 3D CAD, 3D Design, 3D Drafting, 3D Graphic Design, 3D Model Maker, 3D Modelling, 3D Printing, 3D Rendering, Product Design Budget: $10 - $30 USD
Finalize AI Hip Imaging Review Category: Academic Writing, Content Writing, Data Analysis, Medical Research, Medical Writing, Report Writing, Research, Research Writing, Statistical Analysis, Technical Writing Budget: $30 - $250 AUD
Fitness Mobile App Development Category: Fitness, Graphic Design, IPhone, Mobile App Development, Mobile Development, UI / User Interface, User Experience Research, User Interface / IA Budget: $25 - $50 USD
Samsung TV Store Submission Help Category: App Development, App Store Optimization, Documentation, Game Development, Technical Support Budget: $30 - $250 USD
