Can anyone help me with an "IF" statement in Excel?

[mumhadenough]

Typically, I can't get a hold of any of the geeks I work with when I need them!

Can someone help me purleeeeeeeeeeease?

I'm trying to do something so that if cell A2 is Monday, Wednesday, or Friday it returns a certain number. So far I have;

=IF(A2=Monday,"2.75",IF(A2=Wednesday,"1.25", IF(A2=Friday,"2.5")))

Its no working! Giving me the result #NAME? So I know I've did something wrong but I don't know what.

Also tried =IF(A2=Monday,"2.75""0",IF(A2=Wednesday,"1.25""0", IF(A2=Friday,"2.5""0"))) just in case it was because there was no false value

Really really grateful!

Not sure, but wouldn't you have to put Monday in ""?

Hmmmmmmmmmmm will give that a wee go, thanks!

Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Dunno why I didn't see it mind you lol.

Let me know if it works (I have no idea, I'm just guessing - good at excel otherwise, but have never used IF)

What do you want the answer to be if A2 is not Monday, Wednesday or Friday? If nothing, then the formula is =IF(A2="Monday", 2.75,IF(A2="Wednesday",1.25,IF(A2="Friday",2.5,""))) - I think

have you googled tutorials?

You have to tell excel what to put in if none of the arguments are in cell A2, hence the "" at the end of the formula. If you want a value of 0 if not Monday, Wednesday, Friday, then the formula would by ....,IF(A2="Friday",2.5,0)))

without the * of course!

The "" worked, thanks for your help!