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.
Logo Modern Warna Khusus Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design, Visual Design Budget: $250 - $750 USD
Female UGC Creator for Vancouver Denim Brand Category: Content Creation, Content Strategy, Creative Writing, Digital Marketing, Influencer Marketing, Social Media Management, Social Media Marketing, TikTok, Video Editing, Video Production Budget: $50 - $150 CAD
14-May-2026 04:01 GMT
Vintage-Styled Logo for Carl Auto Repair Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: $10 - $30 USD
Asistente Virtual de Estilo de Vida Category: Communications, Conflict Resolution, Consulting, Data Analysis, Data Entry, Data Processing, Microsoft Office, Research, Time Management, Virtual Assistant Budget: $2 - $4 USD
14-May-2026 03:58 GMT
B2B Cold Email Blast to UK Contacts Category: B2B Marketing, Digital Marketing, Email Handling, Email Marketing, Internet Marketing, Lead Generation, Leads, Market Research Budget: £20 - £250 GBP
14-May-2026 03:57 GMT
Expert Developer for Hotel B2B System Category: API Integration, Consulting, MySQL, Payment Processing, PHP, Software Architecture, Web Design Budget: $15 - $25 USD
14-May-2026 03:56 GMT
E-Commerce App UI/UX Design Category: Adobe XD, Figma, Graphic Design, IPhone, UI / User Interface, User Interface / IA, UX / User Experience, Web Design Budget: ₹12500 - ₹37500 INR
