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.
3D Hoodie Model & Texture file off inner hood Category: 3D Animation, 3D Art, 3D CAD, 3D Design, 3D Graphic Design, 3D Illustration, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization Budget: $30 - $250 USD
19-Mar-2026 11:04 GMT
U.S. Email Inbox Manager Category: Admin Support, Customer Service, Customer Support, Data Entry, Email Handling, Time Management, Virtual Assistant Budget: $250 - $750 USD
19-Mar-2026 11:03 GMT
Hire B2B Account Executives Category: Account Management, Business Development, CRM, Hubspot, Lead Generation, Sales, Sales Management, Sales Promotion, Salesforce.com Budget: $30 - $250 USD
19-Mar-2026 11:03 GMT
Cold Caller for Digital Sales Category: Customer Service, Lead Generation, Sales, Sales Management, Sales Promotion, Telemarketing Budget: ₹400 - ₹750 INR
19-Mar-2026 11:03 GMT
Publicação de Empresa na Wikipédia Category: Article Writing, Content Development, Content Management System (CMS), Content Writing, Editing, Proofreading, Research, Wikipedia Budget: $30 - $250 USD
19-Mar-2026 11:02 GMT
Compelling Destination Proposal Copywriting Category: B2B Marketing, Business Writing, Copywriting, Creative Writing, Digital Marketing, Email Marketing, Marketing, Marketing Strategy, Proposal Writing, Public Relations Budget: $8 - $15 USD
19-Mar-2026 11:01 GMT
Grafiche 2D per Videogioco Category: 2D Animation, 2D Animation Explainer Video, 2D Game Art, 2D Layout, Caricature & Cartoons, Game Design, Graphic Design, Illustration Budget: €30 - €250 EUR
19-Mar-2026 11:01 GMT
Crée de logo Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Invitation Design, Logo Design, Print Design Budget: $250 - $750 SGD
19-Mar-2026 11:01 GMT
Consultor Odoo para Empresa MedTech Category: Consulting, Data Analysis, ERP, Inventory Management, Odoo, Python, SAP, Software Architecture Budget: €18 - €36 EUR
19-Mar-2026 11:01 GMT
Administrative Assistant (ET) Category: Admin Support, Data Entry, Email Handling, Excel, Microsoft Word, Time Management, Virtual Assistant, Web Search Budget: $8 - $15 USD
Course Site Edit Pages Category: CSS, Elementor, HTML, PHP, UI / User Interface, Web Design, Web Development, WordPress, WordPress Design Budget: $15 - $25 USD
19-Mar-2026 10:58 GMT
Google First-Page SEO Ranking Category: Content Marketing, Google Analytics, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Website Optimization Budget: ₹1500 - ₹12500 INR
19-Mar-2026 10:58 GMT
Microsoft Power Automate Setup Category: AI Chatbot, AI Content Creation, AI Development, AI Text To Text, Automation, Automation Codeless Program, Microsoft, Microsoft 365 Budget: $15 - $25 AUD