Hi
Put this formula in a cell
=IF(ISERROR(B1:D1),"",B1/C1*D1)
You will have to Ctrl + Shift+ Enter to make it an array formula
Copy down as many lines as needed
HTH
Michael
"Wondering" wrote:
192 31 0.5 3.097
92 12 0.65 4.983
#DIV/0! #DIV/0!
0.000
0.000
0.000
0.000
#DIV/0!
Maybe this will show it better.
|