TRUE/FALSE statements and blank cells

[HugoRune]

Hi Chaps,

Why is it that when I use the following formula in cell C3...=IF(A1>0.95,"A","")

and then in cell A1 i have the formula =IF(ISERROR(B2/B3),"",SUM(B2/B3))

I get the result "A" even though cell A1 results in either a #N/A! #DIV/0! error.


Is there any way around this?

Cheers

 

[Yard]

Excel treats the "" value as being >0.

Just change your A1 formula to

=IF(ISERROR(B2/B3),0,B2/B3)

(in any case, best practice suggests that you should use a zero anyway so that the result in A1 is always numerical)

 

[Yard]

BTW if you are using Excel 2007 or later you can use this in A1:

=IFERROR(B2/B3,0)

 

[cgcamal]

Hi Hugo,

I'm not sure if it is what you need, but if you want to get the value in A1, change from

=IF(A1>0.95,"A","")

to

=IF(A1>0.95,A1,"")

Regards

 

[HugoRune]

Thanks guys,

Just what I wanted.

Time to get cracking