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.
Modern Wedding Invitation Video Category: Adobe Premiere Pro, After Effects, Animation, Color Grading, Film Editing, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
28-Mar-2026 05:03 GMT
Flutter Firebase Phone Auth Fix Category: Android, API Integration, Dart, Flutter, IPhone, Mobile App Development, Mobile Development Budget: $10 - $30 USD
28-Mar-2026 05:03 GMT
Document Consolidation and Formatting Category: Editing, Excel, Microsoft Office, Microsoft Word, Proofreading, Report Writing, Technical Writing, Word, Word Processing, Writing Budget: £20 - £250 GBP
In-Person Survey Data Analysis Category: Data Analysis, Data Management, Data Visualization, Excel, Python, SPSS Statistics, Statistical Analysis, Statistics Budget: ₹12500 - ₹37500 INR
28-Mar-2026 05:02 GMT
Influencer Manager for SaaS Growth Category: Business Analysis, Business Development, Business Plans, Digital Marketing, Influencer Marketing, Internet Marketing, SaaS, Sales Budget: ₹12500 - ₹37500 INR
Edición Profesional de Reels y YouTube Category: After Effects, Animation, Audio Editing, Video Editing, Video Post Editing, Video Processing, Video Services, YouTube Video Editing Budget: $10 - $50 USD
28-Mar-2026 04:55 GMT
Boost Telegram Trading Group Membership Category: Business Analysis, Digital Marketing, Facebook Marketing, Google Adwords, Instagram Ads, Internet Marketing, Management, PHP, Social Media Marketing, Twitter Marketing Budget: ₹1250 - ₹2500 INR
28-Mar-2026 04:54 GMT
Sales Data Forecasting Analysis Category: Data Analysis, Data Analytics, Data Science, Data Visualization, Python, SPSS Statistics, Statistical Analysis, Statistics Budget: ₹12500 - ₹37500 INR
Ассистент рекрутера на удалёнке Category: Customer Service, Data Entry, Human Resources, Interviewing, Recruitment, Virtual Assistant Budget: €2 - €6 EUR
28-Mar-2026 04:52 GMT
Geek & Fandom Social Hub Category: Content Creation, Content Strategy, Facebook Marketing, Research, Social Media Management, Social Media Marketing, Twitter Budget: $30 - $250 USD
