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.
LumiStudy Category: Android, App Design, IOS Development, IPhone, Mobile App Development, Mobile Development, PHP, UI / User Interface Budget: $30 - $250 AUD
17 Jan 2026 22:58 GMT
Rebuild AI Site in WordPress Category: Google Analytics, HTML, PHP, Web Design, Web Development, Website Optimization, WordPress Budget: $250 - $750 USD
17 Jan 2026 22:57 GMT
Website Hero & Logo integration Category: Adobe Illustrator, Photoshop, Banner Design, Graphic Design, Illustration, Logo Design, Web Design Budget: $30 - $250 AUD
Share My Hobby Shop Referral Category: Content Marketing, Digital Marketing, Forum Posting, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO, Social Media Management Budget: $2 - $8 USD
17 Jan 2026 22:55 GMT
Portfolio Website Design & Development Category: Graphic Design, HTML, SEO, UI / User Interface, UX / User Experience, Web Design, Web Development, WordPress Budget: $30 - $250 AUD
17 Jan 2026 22:55 GMT
Finalize and Launch React Native App Category: API Integration, Backend Development, Bill Of Materials (BOM) Optimization, ChatGPT AI Integration, Expo, GitHub, GPT 4, Mobile App Development, Model Testing & Optimization, React Native Budget: $5 - $15 USD
17 Jan 2026 22:53 GMT
QA tester for Dating App MVp -- 2 Category: A / B Testing, Android, API Testing, Backtesting, Mobile App Testing, Quality And Reliability Testing, Regression Testing, Test Automation, Testing / QA, Usability Testing Budget: $250 - $750 USD
Cinematic Motorcycle GoPro Edit Needed Category: Adobe Premiere Pro, After Effects, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Video Services Budget: $30 - $250 USD
17 Jan 2026 22:44 GMT
Bulk Low-Cost Backlink Posts Category: Content Marketing, Digital Marketing, Forum Posting, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO, Social Media Marketing Budget: $10 - $30 USD
17 Jan 2026 22:43 GMT
Site vitrine WordPress clé-en-main Category: HTML, PHP, Web Design, Web Development, WordPress, WordPress Design, WordPress Plugin Budget: $30 - $250 USD
17 Jan 2026 22:41 GMT
UK Company & Payment Setup Category: Accounting, Business Consulting, Business Development, Business Plans, Compliance, Contracts, Finance, Payment Processing, Startup Consulting, Tax Compliance Budget: $50 - $90 USD
