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.
Promo Video Social Media Posts Category: After Effects, Instagram Marketing, Motion Graphics, Social Media Marketing, Video Ads, Video Editing, Video Production, Video Services Budget: $25 - $50 CAD
09-May-2026 15:56 GMT
Instagram Clips Video Editor Category: Adobe Premiere Pro, After Effects, Content Creation, Final Cut Pro, Social Media Marketing, Video Editing, Video Production, Videography Budget: ₹12500 - ₹37500 INR
09-May-2026 15:56 GMT
Perfex CRM Customization for Digital Marketing Agency Category: Agile Development, API Integration, Database Management, HTML, MySQL, PHP, Project Management, Technical Support, Web Development, Web Design Budget: ₹600 - ₹1500 INR
09-May-2026 15:55 GMT
Animated VR Chat Model Creation Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rigging, Animation, Maya Budget: $250 - $750 USD
09-May-2026 15:55 GMT
Merge Three Videos Seamlessly Category: After Effects, Animation, Color Grading, Motion Graphics, Video Editing, Video Post Editing, Video Processing, Video Services Budget: $10 - $30 USD
09-May-2026 15:54 GMT
Excel Project Management Timeline Category: Business Analysis, Data Analysis, Data Entry, Data Management, Data Visualization, Excel, Project Management, Project Planning Budget: $30 - $250 USD
09-May-2026 15:53 GMT
Autoimmunity & Infection Case Report Category: Academic Writing, Case Study Writing, Medical Research, Medical Writing, Report Writing, Research, Research Writing, Scientific Research, Scientific Writing, Technical Writing Budget: $30 - $250 USD
09-May-2026 15:53 GMT
Illustrated Passionate Romance Novel Cover Category: Art Consulting, Book Cover Design, Caricature & Cartoons, Character Illustration, Creative Design, Graphic Design, Illustration Budget: $250 - $750 USD
09-May-2026 15:52 GMT
Travel Blog Informative Article Writer Category: Article Writing, Blog Writing, Content Writing, Copywriting, Ghostwriting, Research, SEO, Travel Writing Budget: £250 - £750 GBP
