MS Excel 2007 IF Function problems.?Solved/Closed

Question

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?

Sanjay · Answer

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

TrowaD · Answer

Hi Twisted,

Can also use a shorter version:
=IF(A1<18,"NO",IF(A1>23.5,"HIGH","YES"))Best regards,
Trowa

MS Excel 2007 IF Function problems.?

2 responses

Similar discussions

Subscribe To Our Newsletter!