I need help with a calculation
In Row 1 below I have a vlookup that is returning a value in column H. Then multiplying that by Column D.
Here is the formula I have and it works correctly.
=IFERROR(VLOOKUP(D2,'Product Data'!A:F,6,FALSE),"")*G2
for the first line the vlookup value is 80.82 x 5 (D2) = 404.10
A B C D E F G H
But if cell d is blank I would like to then divide the vlookup result in H by column F.
Also if there is a value in both Column D and F I would like to do both calculations and then add them together.
Hope this makes sense
Let me know if any other information is needed
In Row 1 below I have a vlookup that is returning a value in column H. Then multiplying that by Column D.
Here is the formula I have and it works correctly.
=IFERROR(VLOOKUP(D2,'Product Data'!A:F,6,FALSE),"")*G2
for the first line the vlookup value is 80.82 x 5 (D2) = 404.10
A B C D E F G H
Item # | Description | Size | Missing Case QTY | Total Invoiced | Missing Bottle QTY | Total Invoiced Bottles | Total $ Loss |
3000 | one | 1.750 LT | 5 | 404.10 | |||
975695 | two | 750.000 ML | 2 |
But if cell d is blank I would like to then divide the vlookup result in H by column F.
Also if there is a value in both Column D and F I would like to do both calculations and then add them together.
Hope this makes sense
Let me know if any other information is needed