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.
Travel Package Promo Videos Category: Adobe Premiere Pro, After Effects, Animation, Color Grading, Maya, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
20-Apr-2026 03:55 GMT
Professional Business Plan Formatting Category: Branding, Business Plan Writing, Data Visualization, Editing, Graphic Design, Microsoft Word, Proofreading, Report Writing, Typography, Visual Design Budget: $30 - $250 USD
20-Apr-2026 03:53 GMT
Urgent Video Needed Category: Video Editing, Video Production, Videography Budget: $100 - $150 USD
Animación Flyers Licores Dinámicos Category: 3D Animation, After Effects, AI Animation, Animation, Blender, Cinema 4D, Graphic Design, Motion Graphics, Video Editing, Video Production Budget: $10 - $20 USD
Instagram Reels Content Planner Category: Content Creation, Content Strategy, Digital Marketing, Instagram Marketing, Social Media Management, Social Media Marketing, Video Editing, Video Production Budget: $30 - $250 SGD
20-Apr-2026 03:44 GMT
Fix Excel Circular References Category: Accounting, Data Analysis, Data Entry, Excel, Excel Macros, Excel VBA, Finance, Research Writing Budget: $10 - $30 AUD
20-Apr-2026 03:39 GMT
Metro 2 Credit Repair SaaS Development Category: API Development, Automation, CRM, Data Analysis, MySQL, PHP, Software Architecture, Software Development Budget: $30 - $250 USD
