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.
Android Social Media App Development Category: Android, Graphic Design, Java, Logo Design, Mobile App Development, UI / User Interface, UX / User Experience Budget: $15 - $25 USD
Arabic Dramatic Reel Editor Category: Adobe Premiere Pro, After Effects, Animation, Color Grading, Motion Graphics, Sound Design, Video Editing, Video Post Editing, Video Services, Visual Effects Budget: $10 - $30 USD
17-Jan-2026 05:04 GMT
Looking for an SEO Expert to Rank My Newly Developed Website Category: Analytics, Competitor Analysis, Content Strategy, Google Analytics, Internet Marketing, Keyword Research, Link Building, Search Engine Marketing (SEM), SEO, Website Optimization Budget: $30 - $250 USD
17-Jan-2026 05:03 GMT
Yucatán Property Buyer Leads Needed Category: Data Mining, Email Marketing, Internet Marketing, Lead Generation, Leads, Market Research, Real Estate, Research Budget: $10 - $30 USD
17-Jan-2026 05:03 GMT
English-Indonesian Fiction Book Translation -- 2 Category: Content Writing, Creative Writing, Editing, English (US) Translator, English Translation, Indonesian Translator, Language Tutoring, Translation Budget: $15 - $25 USD
17-Jan-2026 05:01 GMT
Type Business Report in Word Category: Business Writing, Content Writing, Data Entry, Editing, Excel, Microsoft Word, Report Writing, Word Budget: $250 - $750 USD
17-Jan-2026 05:01 GMT
PDF Text Extraction to Sheets -- 2 Category: Data Analysis, Data Entry, Data Extraction, Data Management, Excel, Google Sheets, PDF, PHP Budget: $99 - $100 USD
17-Jan-2026 05:00 GMT
Konten sederhana Category: Content Creation, Content Writing, Copywriting, Creative Writing, Digital Marketing, Instagram Marketing, Social Media Management, Social Media Marketing Budget: $2 - $8 USD
Shopify Template Store Setup Category: Digital Marketing, HTML, Payment Gateway Integration, Shopify, Shopify Development, Shopify Templates, Web Design Budget: $30 - $250 USD
17-Jan-2026 04:59 GMT
Bakery POS & Inventory System Category: Android, C#, Programming, Inventory Management, IOS Development, Mobile App Development, PHP, Point Of Sale, Software Architecture, Web Development Budget: $15 - $25 USD
17-Jan-2026 04:59 GMT
Shopify Cart Drawer Fix Category: CSS, Debugging, Frontend Development, JavaScript, Shopify, Shopify Templates, Web Design, Web Development Budget: $10 - $30 USD
