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.
Global IT Lead Generation- Business development Category: Business Development, Full Stack Development, Graphic Design, HTML, Lead Generation, Shopify Templates, Web Development, Web Design, WordPress Budget: ₹12500 - ₹37500 INR
25-Feb-2026 17:04 GMT
Salds-Focused Google Ads Manager Category: Article Writing, Digital Marketing, Google Ads, Google Adwords, Google Analytics, Internet Marketing, PPC Marketing, SEO Budget: ₹12500 - ₹37500 INR
25-Feb-2026 17:03 GMT
US Carrier Call Quality Testing -- 2 Category: Asterisk PBX, Audio Services, Call Center, Telecom Sales, Telecommunications Engineering, Voice Over, Voice Talent, VoIP Budget: $15 - $25 USD
25-Feb-2026 17:02 GMT
Develop AI-Driven Expense Tracker for Finance App Category: AI Development, AI Model Development, Graphic Design, Machine Learning (ML), Mobile App Development, User Interface / IA, UX / User Experience, Web Design Budget: ₹1500 - ₹12500 INR
25-Feb-2026 17:01 GMT
Video Tutorial Cara Kerja SE Category: Adobe Premiere Pro, Animation, Content Creation, Final Cut Pro, Storyboard, Video Editing, Video Production, Voice Over Budget: $15 - $25 USD
25-Feb-2026 17:00 GMT
Classic Victoria Table/Sofa Legs STL Category: 3D Animation, 3D CAD, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max, Aspire, CNC, Rhino 3D Budget: $30 - $250 USD
25-Feb-2026 17:00 GMT
Closed-Platform Employee Loyalty Mobile App Category: Android App Development, Backend Development, Cloud Computing, HTML, IOS Development, Mobile App Development, PHP, User Experience Research, User Interface / IA, Web Design Budget: $20000 - $50000 USD
Romantic Short Story Needed Category: Book Writing, Content Writing, EBooks, Editing, Fiction, Ghostwriting, Romance Writing, Writing Budget: $750 - $1500 USD
25-Feb-2026 17:00 GMT
Fully Automated Social Media Workflow Category: API, Automation, JavaScript, PHP, Python, Social Media Management, Software Architecture, Zapier Budget: $50 - $150 USD
25-Feb-2026 17:00 GMT
Creative Website of Finance Category: Animation, Figma, Next.js, React.js, SEO, Web Development Budget: ₹12500 - ₹37500 INR
25-Feb-2026 16:59 GMT
US Carrier Call Quality Testing Category: Asterisk PBX, Audio Services, Call Center, Telecom Sales, Telecommunications Engineering, Voice Over, Voice Talent, VoIP Budget: $15 - $25 USD
25-Feb-2026 16:59 GMT
Document Verification at Santa Sofia Ips Category: Admin Support, Customer Service, Data Entry, Documentation, Local Job, Public Relations, Report Writing, Research, Time Management Budget: $10 - $30 USD