ifferror show 0

[sam__gleeson]

Hi

I have this formula for calculating %

=D25/(D$19*60)*100

It gives a #DIV/0! if a 0 in D25 so I used the following formula but it does not display a 0 if there is a error in the cell D25

=IFERROR(D25/(D$19*60)*100,"0")

D25 = Time in minutes
D$19 = 8 hours

Thanks

 

[ukmikeb]

Hi

Check again!

It gives #DIV/0! if there is 0 in D19.

The IFERROR works for me for the above and for alpha characters in D25.

hth

 

[sam__gleeson]

Hi

I have the following....cell still empty with following

=D25/(D$19*60)*100

D25 = 0
D19 = 8

0/(8*60)*100 = 0/48000

 

[ukmikeb]

Hi

If D25 is "empty" (ie Null) the division coerces its value to zero.

If you have a space in D25, the formula in post 3 will show a "#VALUE!" error and the IFERROR formula will show a "0" in the left of the cell indicating - text.

I think now both my posts have catered for all eventualities.

 

[sam__gleeson]

I worked it out - I had the cell formatted as 0;-0;