# =if(condition,,)

#### lezawang

##### Well-known Member
Hi
Why this formula is giving me 0

=IF(E2>50, ,)

I thought it should give me True if E2 > 50 and False if E2 < 50

because I did not specify what would be if the condition is True or False. Thank you very much.

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### DanteAmor

##### Well-known Member
You must specify the true one, for example:

=IF(E2 > 50,TRUE)

• lezawang

#### silentwolf

##### Well-known Member
Hi,
=if(E2>50,True,False)

• lezawang

#### offthelip

##### Well-known Member
if is because "If" statement has the form =IF( test condition, value if test condition is TRUE, Value if Test condition is false)
You have got NOTHING in both the true case and the false case so it returns nothing
what you need is
=E2>50
this will give you TRUE and FAlSE
or
= IF(E2>50,TRUE,FALSE)

Last edited:
• lezawang

#### Scott Huish

##### MrExcel MVP
Just to return TRUE/FALSE:
=E2>50

Last edited:

#### Nothnless

##### Board Regular
Because E2 is greater than 50.

#### lezawang

##### Well-known Member
Thank you all. I appreciate your help.

Youre welcome