View Single Post
  #3   Report Post  
Michael
 
Posts: n/a
Default

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.