Excel 2007 - Multi IF function?

Question

=IF(A2="Monday","9", "NA")
Im trying to work this out but this isnt working for me - i want to see if A2="Monday" "Tuesday" "Wednesday" "Thursday" "Friday" or "Saturday" return "9"..... and if A2="Sunday" return "10".
This formula (=IF(A2="Monday","9", "NA") is working. but when i put more this one days inside, it stops working. is there a way to do that?
any help will me good.

i think its called Multi IFs

Answer 1

you can use OR e.g.
=IF(OR(A2="Monday",A2="Tuesday", A2="Wednesday", A2="Thursday", A2="Friday",A2="Saturday"),"9","NA")

but considering the data we have here I would rather use opposite approach using AND:

=IF(AND(A2<>"",A2<>"Sunday"),"9","NA")

Hope this helps

Answer 2

You could easily do that with one simple formula:

=IF(A2 = "Sunday", 10 , 9)

This sets your value to 10 if A2 equals Sunday, otherwise for all other values (Monday-Saturday) your value is 9.

There is only one problem with this formula and that is you could put the word "Blue" or any other value besides Sunday in for A2 and the formula would return 9.

You could layer a second if in the formula to take care of that.

I think a better way to do it would be to use actual dates and use the WEEKDAY function. For instance you could put the actual date in A2.

=IF(WEEKDAY(A2,1)=1, 10, 9)

Answer 3

Try this
=if(a2="Sunday","10","9")

Answer 4

even if version of Excel you're utilising, the make up of the function continues to be the same, i.e. =sumif(cellref,standards). only the two parameters as in assessment to a common if function you do no longer want a 0.33 parameter as you're no longer doing something with the cells that don't meet the factors.