=if(condition,,)

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
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.
 

Some videos you may like

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
Joined
Dec 3, 2018
Messages
10,222
Office Version
2007
Platform
Windows
You must specify the true one, for example:

=IF(E2 > 50,TRUE)
 

offthelip

Well-known Member
Joined
Dec 23, 2017
Messages
1,079
Office Version
2010
Platform
Windows
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:

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,937
Office Version
365, 2010
Platform
Windows
Just to return TRUE/FALSE:
=E2>50
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,089,961
Messages
5,411,526
Members
403,375
Latest member
vba33

This Week's Hot Topics

Top