IF formula with errors

  • Thread starter Thread starter Jessica Walton
  • Start date Start date
J

Jessica Walton

Another question--

Here's another formula I'm using within my spreadsheet:

=IF(G16<=0.5,0,IF(G16>=1.5,F17*0.5,F17*G18))

How can I also tell this to print a zero if the data it is
looking at is filled with zeros creating a #div/0! error?
Jessica
 
The formula below is in a cell which is fed from answers
of other cells. When those cells are populated with
zeros, I get the #DIV/0 error. I used the following the
solve the problem, based on an answer I got to a previous
question--

=IF(ISERROR(((F17/F16)*0.5)-0.25),,(((F17/F16)*0.5)-0.25))

which produced a zero and fed into the cell with a
zero...thus, solving the problem.

Thanks anyway...I must be learning a thing or two here!!
Jessica
 
Back
Top