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.
Beginner AWS Live Training Category: Amazon Web Services, Cloud Computing, Database Management, Linux, Programming, Software Development, Technical Writing, Ubuntu Budget: ₹12500 - ₹37500 INR
18-Nov-2025 05:04 GMT
2D Explainer Video Animation Category: 2D Animation, 2D Animation Explainer Video, 3D Animation, A / V Editing, After Effects, Animation, Video Production, Video Services Budget: $14 - $30 NZD
18-Nov-2025 05:03 GMT
Comprehensive Trading ERP Desktop App Category: Accounting, Business Analysis, Database Development, Desktop Application, ERP, Project Management, Software Development, Software Engineering, User Interface / IA Budget: ₹1500 - ₹12500 INR
Classic Lawn Care Logo Design Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: $30 - $250 USD
18-Nov-2025 05:02 GMT
Promote my Instagram and Youtube & Facebook pageVideo views Category: Analytics, Content Marketing, Digital Marketing, Facebook Marketing, Influencer Marketing, Instagram Marketing, Internet Marketing, Marketing Strategy, Social Media Marketing, YouTube Budget: ₹600 - ₹1500 INR
18-Nov-2025 05:01 GMT
Social Media Video & Graphics Category: Adobe Illustrator, Photoshop, Adobe Premiere Pro, After Effects, Animation, Graphic Design, Video Editing, Video Production Budget: ₹1500 - ₹12500 INR
18-Nov-2025 04:59 GMT
Cinematic Drone & Ground Video Edit Category: Adobe Premiere Pro, After Effects, Animation, Color Grading, DaVinci Resolve, Video Editing, Video Production, Video Services Budget: ₹1250 - ₹2500 INR
18-Nov-2025 04:58 GMT
Android Logistics App Figma Design Category: Android, Facebook Ads, Figma, Google Adsense, Google Analytics, Graphic Design, Linkedin, Mobile Development, SEO Writing, Web Design Budget: ₹12500 - ₹37500 INR
18-Nov-2025 04:58 GMT
Strategi Influencer Fashion Instagram Category: Article Writing, Content Creation, Content Writing, Copywriting, Data Entry, Fashion Consulting, Instagram Marketing, Social Media Marketing Budget: $8 - $15 USD
18-Nov-2025 04:58 GMT
Virtual Admin Assistant Needed Category: Admin Support, Data Processing, Excel, Microsoft Word, Virtual Assistant Budget: $10 - $30 USD
18-Nov-2025 04:57 GMT
Strategi Pemasaran TikTok Category: Analytics, Content Creation, Content Strategy, Digital Marketing, Influencer Marketing, Social Media Management, Social Media Marketing, Video Production Budget: $250 - $750 USD
