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.
Tutorial Video Editing with Effects Category: After Effects, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services, Visual Effects, YouTube Budget: €12 - €18 EUR
Trendy Short-Form Social Video Editing Category: After Effects, CapCut, Social Media Marketing, Templates, Video Editing, Video Post Editing, Video Services Budget: $10 - $30 USD
10-Jan-2026 16:59 GMT
US Illustrator for Memoir Cover Category: Adobe Illustrator, Photoshop, Book Cover Design, Graphic Design, Illustration, Print Design Budget: $250 - $750 USD
Android Social Community App Build Category: Android, Android App Development, Android Studio, Backend Development, IPhone, Java, Kotlin, Mobile App Development Budget: $15 - $25 USD
10-Jan-2026 16:53 GMT
All-Day Android Recorder Category: Android App Development, Android SDK, Mobile App Development Budget: $30 - $250 USD
10-Jan-2026 16:51 GMT
Looking for Ad Video Creator (Mobile App Promotion) Category: Advertising, Facebook Marketing, Social Media Marketing, Video Ads, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
10-Jan-2026 16:49 GMT
Affiliate Marketer for Medical Study Inputs Category: Content Marketing, Digital Marketing, Facebook Marketing, Internet Marketing, Marketing Strategy, Research, Social Media Marketing Budget: $10 - $30 USD
10-Jan-2026 16:48 GMT
Realistic Couple Pencil Portrait Category: 3D Modelling, 3D Rendering, Creative Design, Illustration, Photoshop, Visual Arts Budget: $30 - $250 USD
