An "IF" formula

[Pauls123]

Hi, When attempting to apply an "IF" formula to a cell, eg

=IF(BG2<5,"yes","no")

If BG2 already has a formula in it to give it a value, my "IF" formula keeps coming up as "no". Even though the value is less than 5.

Any reason for this and any way to fix it,.?

Regards, Paul

 

[repairman615]

Hello,

In cell BG2 at the end of your formula add +0


In other words, if your formula is

=(2+2)

then try

=(2+2)+0

 

[repairman615]

Here is another option:

<TABLE style="WIDTH: 156pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=208><COLGROUP><COL style="WIDTH: 156pt; mso-width-source: userset; mso-width-alt: 3803" width=208><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; WIDTH: 156pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=208>=IF(VALUE(BG2)<5,"Yes","No")</TD></TR></TBODY></TABLE>

BG2 may be as text which would evaluate to "No" without regard to the values.

 

[Pauls123]

thanks Repairman, very impressed, that worked,

Regards
Paul

 

[Aladin Akyurek]

=IF(N(BG2) < 5, "yes", "no")

if BG2 can house a formula blank or non-coercible text.