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.
3D Animated Business Card Design Category: 3D Animation, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, After Effects, Animation, Graphic Design Budget: $2 - $8 USD
14-Apr-2026 22:03 GMT
Promotional Social Media Post Design Category: Photoshop, Branding, Graphic Design, Illustration, Instagram Marketing, Logo Design, Social Media Management Budget: $30 - $250 USD
US Wise Account Verification Help Category: Account Management, Banner Design, Customer Service, Customer Support, Graphic Design, Logo Design, Photo Editing, Photoshop Budget: $10 - $30 USD
14-Apr-2026 21:49 GMT
Secure Biometric Registration Desktop Application Category: Android, API Integration, C#, Programming, Encryption, Mobile App Development, Software Architecture, Windows Desktop, WPF Budget: ₹1500 - ₹12500 INR
14-Apr-2026 21:48 GMT
AI Agents for MVP Category: Agentic AI, AI Agents, AI Development, Google Cloud Platform Budget: $15 - $25 USD
14-Apr-2026 21:44 GMT
Modern Vacation Home Design Category: 3D Modelling, 3D Rendering, 3D Visualization, Architecture, Building Architecture, Building Design, Building Engineering, Interior Design Budget: $250 - $750 AUD
14-Apr-2026 21:42 GMT
Boost My Site’s Technical SEO Category: Google PageSpeed Insights, Internet Marketing, Link Building, PHP, SEO, Web Design, Web Development, Website Optimization Budget: £20 - £250 GBP
14-Apr-2026 21:41 GMT
SQL Server Query Failure Analysis Category: Data Analysis, Data Processing, Database Administration, Database Design, Database Management, Database Programming, Microsoft SQL Server, MySQL, Performance Tuning, SQL Budget: $30 - $250 USD
14-Apr-2026 21:41 GMT
Redesign Existing Website Category: CSS, Graphic Design, HTML, PHP, SEO, User Interface / IA, Web Design, Web Development, Website Optimization Budget: $30 - $60 NZD
14-Apr-2026 21:41 GMT
Launch My Google & Meta Leads Category: Digital Marketing, Google Ads, Google Adwords, Instagram Marketing, Internet Marketing, Lead Generation, Marketing, Sales Budget: ₹600 - ₹1500 INR
