IF Function

J

JessC

Joined
Dec 18, 2008
Messages
2
Reaction score
0
Hi all,

Just wondering if anyone can help. I am trying to create an IF function that tests the criteria for two different cells, and if both pass the criteria return true or false. E.g IF A2 & A3 >30 "TRUE" or "FALSE". I have tried the help menu but with no luck.

Anyone out there who isa wizz at excel ??

Thanks,

Jess
 
Hello JessC

Here you go ...
=IF(B3+C3=30,"True","False")

just change the equal sign to any criteria you want ..ie. >= or <= etc..
 
Last edited:
Hi Rush,

The formula I am trying to create is to test two cells, not add them together. I want it to tell me if both cells equal 30% or more then the answer is true, if one cell equals 30% or more the answer is true, then if both are less than 30% then the answer is false.
 
Back
Top