MS Excel 2007 IF Function problems.? [Solved/Closed]

Report
-
 Twisted -
Hello,

I need immediate assistance. basically i am trying to use the IF function to display
less than 18 "no",
more than 18 "yes".
but if 23.5/> "HIGH"
been trying for hours! need help asap. tried nesting.
=IF(G3<18,"No",IF(G3>18<23,"Yes",IF(G3>23.5"HIGH")))
failed...

closest i got was something like
=IF(G9<18,"NO","YES"+IF(G9>23.5,HIGH)
still not working. is there something i am doing wrong? need help asap!
thanks

is there something im doing wrong? or am i just way off?

2 replies

=IF(A1<18,"NO",IF(A1>23.5,"HIGH",IF(A1>=18,"YES") ))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
Hi Twisted,

Can also use a shorter version:
=IF(A1<18,"NO",IF(A1>23.5,"HIGH","YES"))
Best regards,
Trowa
:)
THANK YOU!
very much

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!