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.
Looking RTX guy for Rendering Blender Animation Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Animation, Blender Budget: $10 - $30 USD
14-Feb-2026 23:00 GMT
Home Spiritual Business Workflow Design Category: Business Analysis, CRM, Data Management, Fashion Modeling, Graphic Design, Personal Development, PHP, Process Automation, Project Management, Web Design Budget: $250 - $750 USD
5K Genuine Instagram & Facebook Followers Category: Branding, Content Marketing, Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Social Media Management, Social Media Marketing, Social Networking, Twitter Budget: $30 - $250 USD
14-Feb-2026 22:55 GMT
Xactimate Estimate for Home Repairs Category: AutoCAD, Building Architecture, Building Design, Construction, Home Design, Interior Design, PDF Budget: $250 - $750 USD
VR Gorilla Tag Fan Game Category: Game Development, Game Testing, Unity, Unity 3D, Unreal Engine, Virtual Reality Budget: $2 - $8 CAD
14-Feb-2026 22:50 GMT
Life Coaching Site Build Category: CMS, Graphic Design, HTML, Payment Processing, PHP, Web Design, Web Development Budget: $30 - $250 USD
14-Feb-2026 22:49 GMT
Modernize Classic PC Game Performance Category: C, Programming, C++, DirectX, Game Design, Game Development, Game Testing, Software Development, Unity 3D Budget: £250 - £750 GBP
AI Marketplace Web App Category: AngularJS, Express JS, Full Stack Development, JavaScript, MongoDB, Next.js, Payment Gateway Integration, REST API, Tailwind CSS, Web Development Budget: £750 - £1500 GBP
14-Feb-2026 22:46 GMT
Home design: Tweak 3D Elevation Around Window Category: 3D Animation, 3D Architecture, 3D Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, SketchUp Budget: ₹600 - ₹1500 INR
14-Feb-2026 22:44 GMT
Transparent Video Overlay Creation Category: After Effects, Video Editing, Video Processing, Video Production, Video Services, Video Streaming Budget: $30 - $250 AUD
14-Feb-2026 22:40 GMT
Small Business Sales Outreach Category: Internet Marketing, Lead Generation, Leads, Sales, Sales Account Management, Sales Management, Sales Promotion, Telemarketing Budget: $250 - $750 AUD
