Excel excel if function

[xaviera]

I just cannot work the function out , please help

I would like to have a box to show
1. three s/s and smaller than 10days is URTI
2. if not URTI then check if there is three s/s and smaller than 10days for GE,
3. if not, then " "

I typed the following, but it said cannot work, please help

=IF(AND(V12>=3,Y12>=10),"URTI", IF(AND(W12>=3, Y12>=10,"GE)), " ")

 

[Becky]

Sorry for the late reply, I've only just seen your post.

>= means 'greater than or equal to', so I think you need to change some of your operators (ie < & >).

If my understanding is correct, it should be:

=IF(AND(V12<=3,Y12<10),"URTI", IF(AND(W12>=3, Y12>=10,"GE")),"")

This says: If V12 is less than or equal to 3 and Y12 is less than 10, then the result is URTI. If not, then if W12 is greater than or equal to 3 and Y12 is greater than or equal to 10, then the result is GE. If neither of these options are true, the result is blank.

 

[xaviera]

Dear Becky,

thanks for your reply

it cannot used if I type your equation
I do want to have a function that
V10 greater than or equal to 3 while Y10 less than 10, then the result is URTI,
if not, then if W10 greater than or equal to 3 while Y10 is less than 10, then the result is GE
if neither options are true, the result is blank

thank you

 

[Becky]

Ah ok, hopefully this should work:

=IF(AND(V10>=3,Y10<10),"URTI", IF(AND(W10>=3, Y10<10),"GE",""))