Getting the wrong result on a formula??

[dollyann]

Hi

This is probably simple, but i can't figure it out and hoping someone can answer me?

In cell A1 = 0
In cell A2 = is a formula (=IF(A1<23,"Below",if(A1>25,"Above","Target"))

The result comes back as Above instead of Below, how do i get the result to say Below as the answer is zero?

Please can someone help as it's driving me potty....lol :0)

Thanks you

 

[tigeravatar]

dollyann,

The only thing I can think of is that your cell A1 is formatted as text, or instead of a zero it contains the letter o. That would cause the behavior you're seeing.

~tigeravatar

 

[dollyann]

Hi

Thanks for answering so quickly.

In cell A1 there is a formula

=IF(b1=0,"£0.00",SUM(b2/b3))

But all the 0's are numbers not text.

Any more ideas why?

Thank you

 

[RoryA]

=IF(b1=0,"£0.00",SUM(b2/b3))
returns £0.00 as text, not a number. You should use:
=IF(b1=0,0,SUM(b2/b3))
and format the cell to show the pound sign instead.

 

[tigeravatar]

dollyann,

The £ symbol in your formula is text and is causing the result to be a text expression, not a numeric one. Instead, format the cell as currency and leave the £ symbol out of the formula:
=IF(b1=0,0,SUM(b2/b3))

~tigeravatar

 

[dollyann]

That's great. It works now!!....Yippeee!!

Thank you very much on your help :0)