Forum Discussion
Nested IF function or???
Hello, I am trying to create a time sheet that will populate the invoice amount. I have several drop down lists on another tab to choose certain info from that will populate on the first tab. I wou...
mathetes
Ok, I figured out the VLOOKUP part with this =VLOOKUP(B11,'Dropdown Lists'!A3:D91,2,FALSE). Itt brings back 0.45, which is correct. Now I need it to take that 0.45 (as a percent) and multiply it by the value in another cell. How do I embed a formula into the one I have already in order for the worksheet to do the math? The above link will take you to the worksheet.
Thanks a million!!
Ok, I figured out the VLOOKUP part with this =VLOOKUP(B11,'Dropdown Lists'!A3:D91,2,FALSE). Itt brings back 0.45, which is correct. Now I need it to take that 0.45 (as a percent) and multiply it by the value in another cell. How do I embed a formula into the one I have already in order for the worksheet to do the math? The above link will take you to the worksheet.
Thanks a million!!
Yes, the link to Google Sheets work just fine
Now you need to point me to the cell where your VLOOKUP is, and the cell(s) where you're wanting to do those calculations.
Now you need to point me to the cell where your VLOOKUP is, and the cell(s) where you're wanting to do those calculations.
- Great! Ok, the VLOOKUP is on the TS-1 tab, cell O17. The table is on the Dropdown Lists tab, cell A1 - D91.
On the TS-1 tab, I want cell O17 to calculate the regular hourly bill rate, and Q17 to calculate the OT bill rate. O17 should take the appropriate percentage rate (attached on the Dropdowns Lists tab in cells B, C, & D 1-91 and formulated with VLOOKUP) I believe I have Q17 set up properly already. I was able to get part of the way through the formula but ran into a snag when the vlookup did pull the corresponding percentage rate, but the math I did added the percentage as a decimal to the value of N17, which is not correct. Ultimately, the math should be N17 * percentage rate for site listed in B11. Thanks for all your direction.