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.
Edição Rápida para TikTok Category: Adobe Premiere Pro, CapCut, Final Cut Pro, TikTok, Video Editing, Video Post Editing, Video Production, Video Services Budget: $30 - $250 USD
Realistic Vector Art for T-Shirts Category: Adobe Illustrator, Creative Design, Digital Art, Graphic Design, Illustration, Photoshop, Print Design, T Shirts, Vector Design Budget: $1500 - $3000 CAD
30-Dec-2025 22:57 GMT
Executive Strategy Memo Slides Category: 3D Graphic Design, Business Strategy, Canva, Graphic Design, Powerpoint Budget: $10 - $30 USD
30-Dec-2025 22:56 GMT
Etsy Long-Tail Keyword Research Category: Data Analysis, Etsy, Internet Marketing, Keyword Research, Link Building, Market Research, Search Engine Marketing (SEM), SEO Budget: €12 - €18 EUR
30-Dec-2025 22:54 GMT
Flutter Expert for "Fire Burn" Effect Category: 3D Animation, Animation, C++, Programming, Dart, Flutter, Graphics Programming, Mobile App Development, OpenGL Budget: $30 - $250 CAD
30-Dec-2025 22:53 GMT
15-Second Trophy Camera Animation Category: 3D Animation, 3D Modelling, 3D Rendering, 3D Studio Max, After Effects, Blender, Cinema 4D, Maya Budget: ₹600 - ₹1500 INR
30-Dec-2025 22:52 GMT
Articles Maladies Santé Optimisés SEO Category: Article Writing, Blog Writing, Content Writing, Copywriting, French Translator, Medical Writing, Research Writing, SEO Writing Budget: $250 - $750 USD
30-Dec-2025 22:49 GMT
Multi-Channel Etsy Marketing Category: Email Marketing, Facebook Ads, Facebook Marketing, Google Ads, Internet Marketing, Search Engine Marketing (SEM), Social Media Marketing, Twitter Budget: ₹1500 - ₹12500 INR
30-Dec-2025 22:48 GMT
I need a cold caller Category: Account Management, Customer Service, Customer Support, Internet Marketing, Lead Generation, Sales, Telemarketing, Voice Talent Budget: $10 - $30 USD
30-Dec-2025 22:48 GMT
Continuous Order Acceptance Assistant Category: Android, IPad, IPhone, Mobile Accessibility, Mobile App Development, Mobile App Testing, Mobile Development, User Experience Research Budget: $2 - $8 USD
