MS Excel 2007 IF Function problems.?

Solved/Closed
Twisted - Dec 23, 2010 at 12:05 AM
 Twisted - Dec 23, 2010 at 02:50 PM
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?
Related:

2 responses

=IF(A1<18,"NO",IF(A1>23.5,"HIGH",IF(A1>=18,"YES") ))
1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 23, 2010 at 09:22 AM
Hi Twisted,

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