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.
Videomaker para Marca de Cuidado Capilar Category: Catch Phrases, Content Creation, Instagram Marketing, Slogans, Social Media Marketing, Video Editing, Video Production, Videography Budget: €30 - €250 EUR
02-Apr-2026 15:59 GMT
Specjalista Meta Ads do E-Commerce Category: Advertising, Content Creation, Conversion Rate Optimization, Digital Marketing, Facebook Ads, Graphic Design, Instagram Marketing, Social Media Marketing Budget: $30 - $250 USD
02-Apr-2026 15:59 GMT
Senior Data Scientist for Advanced LLM Workflow Category: A / B Testing, Artificial Intelligence, Data Analysis, Data Science, Hadoop, Machine Learning (ML), NumPy, Pandas, Python, SQL Budget: min $50 USD
West Bank Human Rights Calls in Arabic Category: Arabic Translator, Data Entry, Legal Research, Public Relations, Research, Research Writing Budget: $2 - $8 USD
02-Apr-2026 15:57 GMT
Modern Logo & Font for Fordj Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Typography, Vector Design Budget: $10 - $30 AUD
02-Apr-2026 15:57 GMT
ITR Filing Website Development Category: Database Management, Full Stack Development, HTML, MySQL, PHP, Security, Web Development, Web Design Budget: ₹1500 - ₹12500 INR
02-Apr-2026 15:57 GMT
Company Site Verification in Jasło, Poland Category: Data Collection, Data Entry, Geolocation, Internet Research, Photo Editing, Photography, Remote Sensing Budget: $70 - $80 USD
02-Apr-2026 15:56 GMT
Micro task specialist Category: Copy Typing, Customer Service, Data Entry, Data Processing, Project Management, Research, Statistics, Time Management, Web Search Budget: $15 - $25 USD
ERP System with Mobile App for Manufacturing Category: Accounting, Android, Data Analytics, ERP, Inventory Management, IOS Development, IPhone, Mobile App Development, Odoo, PHP Budget: ₹1250 - ₹2500 INR
02-Apr-2026 15:51 GMT
Kundali System Repair on WordPress Category: API, Database Design, Database Management, MySQL, PHP, Web Development, WordPress Budget: ₹2000 - ₹3000 INR