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.
Modern Logo With Text & Icon Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Typography, Vector Design Budget: ₹100 - ₹400 INR
02-Dec-2025 17:04 GMT
SEO & Digital Marketing Proposal for Oliver Fox Category: Content Marketing, Digital Marketing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Social Media Marketing Budget: $30 - $250 USD
Minimalist Neutral Home Décor Canvas Category: Adobe Illustrator, Photoshop, Digital Art, Graphic Design, Illustration, Logo Design, Procreate Budget: $15 - $25 USD
02-Dec-2025 17:02 GMT
Pine Script Developer Category: Data Analysis, Data Visualization, Financial Analysis, Financial Consulting, Investment Management, Market Research, Pine Script, Risk Management Budget: ₹400 - ₹750 INR
02-Dec-2025 17:01 GMT
Real Estate Promo Video Editing Category: Adobe Premiere Pro, Audio Editing, Commercials, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
Game 3D Character Animations Category: 3D Animation, 3D Art, 3D Design, 3D Modelling, 3D Rendering, 3D Rigging, Animation, Game Development, Maya Budget: $500 - $1000 USD
02-Dec-2025 17:00 GMT
Clone alphadatabase.in WordPress Site Category: Graphic Design, HTML, PHP, SEO, Web Design, Web Development, WordPress, WordPress Design, WordPress Plugin Budget: ₹600 - ₹1500 INR
02-Dec-2025 16:59 GMT
Louisiana Urgent Care Directory Category: Data Collection, Data Entry, Data Management, Excel, Google Sheets, Lead Generation, Research, Web Search Budget: $10 - $30 USD
02-Dec-2025 16:58 GMT
UI/UX Figma Design for Personal Finance App Category: App Design, Branding, Figma, Gamification, Graphic Design, UI / User Interface, User Interface / IA, User Research, UX / User Experience, Web Design Budget: ₹1500 - ₹12500 INR
02-Dec-2025 16:58 GMT
Mystical Wellness Website Build Category: Content Writing, Elementor, HTML, PHP, SEO, UI / User Interface, Web Design, Web Development, WordPress Budget: ₹600 - ₹1500 INR
