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 2821 users have said thank you to us this month

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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