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.
Remote Customer Data Entry Clerk Category: Customer Service, Data Entry, Data Management, Data Processing, Excel, Image Processing, Typing, Word Budget: $15 - $25 USD
Full-Stack E-Commerce Store Build Category: API Development, ECommerce, Full Stack Development, HTML, PHP, Vue.js, Web Development, Web Design Budget: $1500 - $3000 USD
US Construction CFO Email Leads Category: CRM, Data Collection, Data Entry, Data Management, Database Development, Email Marketing, Excel, Leads Budget: $30 - $250 USD
Luxury Estate Video Tours Gurgaon Category: After Effects, Cinematography, Color Grading, Drone Photography, Video Editing, Video Production, Video Services, Video Tours Budget: ₹600 - ₹1500 INR
Urgent Pixel-Perfect Responsive HTML Fixes Category: Bootstrap, CSS, Figma, Frontend Development, HTML, HTML5, JavaScript, Web Design, Web Development Budget: $10 - $30 USD
10 Sep 2025 21:53 GMT
Forum Setup With Badged Groups Category: Forum Software, MyBB, MySQL, Payment Gateway Integration, PHP, PhpBB, Web Development, WordPress Budget: €30 - €250 EUR
