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.
Instagram Reels Ad Video Editor Category: Adobe Premiere Pro, After Effects, Animation, Final Cut Pro, Motion Graphics, Video Ads, Video Editing, Video Services Budget: ₹12500 - ₹37500 INR
05-Apr-2026 10:03 GMT
App Media Sosial dengan Pesan Category: Android, App Store Optimization, Backend Development, Flutter, IPhone, Mobile App Development, PhoneGap, React Native Budget: $15 - $25 USD
05-Apr-2026 10:01 GMT
Flat Fuel Finder Icon Design Category: Adobe Illustrator, Photoshop, Graphic Design, Icon Design, Logo Design, UI / User Interface, User Interface / IA, Vector Design Budget: $10 - $30 AUD
05-Apr-2026 09:59 GMT
Cartoon 3rd-Person Mission Game Category: 3D Animation, Animation, Game Design, Game Development, Graphic Design, Illustration, Unity, Unreal Engine Budget: £20 - £250 GBP
Bimbingan Freelance Ilustrasi Online Category: Art Consulting, Content Strategy, Creative Design, Design Thinking, Digital Art, Graphic Design, Illustration, User Experience Research Budget: $250 - $750 USD
05-Apr-2026 09:57 GMT
Viral Instagram Reels Editing Category: Adobe Premiere Pro, After Effects, Animation, CapCut, Final Cut Pro, Motion Graphics, Video Editing, Video Production Budget: ₹400 - ₹750 INR
05-Apr-2026 09:53 GMT
YouTube, Instagram & Wallpaper Edits Category: Adobe Premiere Pro, After Effects, Animation, DaVinci Resolve, Final Cut Pro, Graphic Design, Video Editing, Video Services Budget: ₹12500 - ₹37500 INR
05-Apr-2026 09:50 GMT
Launch New Product Line Store Category: HTML, Inventory Management, PHP, Product Management, Shopify, Shopify Development, Shopify Templates, Web Development Budget: $30 - $250 USD
05-Apr-2026 09:48 GMT
Cross-Platform Mobile App UI/UX Category: Android, Figma, IOS Development, IPhone, Mobile App Development, UI / User Interface, User Interface / IA, UX / User Experience Budget: $30 - $250 USD
AI Transcription Tool - Content Needed Category: AI Content Writing, Article Writing, Content Writing, Copywriting, Ghostwriting, Product Descriptions, SEO Writing, Technical Writing Budget: £2 - £5 GBP
05-Apr-2026 09:45 GMT
Full-Time YouTube Video Editor (Monthly Salary) Category: Adobe Premiere Pro, After Effects, Commercials, Final Cut Pro, Motion Graphics, Video Editing, Video Post Editing, Video Production, YouTube Budget: €2 - €6 EUR