If Else formula including dates

[disarae]

Hi,
Using Excell 2011 on a Mac.

I'm trying to get a formula to say if cell A1 = Mon, then 3.25. If A1 = Tue, then 5...and so on throughout the week.

I've tried several situations with this, the most recent was
=IF(H12="Mon",3,IF(H12="Tue",3.75,IF(H12="Wed",4.25,IF(H12="Thu",3.75,IF(H12="Fri",3.75,IF(H12="Sat",0,IF(H12="Sun",0)))))))

Even when I do one IF statement at a time like =IF(A1="Mon",3,0)
It is reading at 0 or FALSE, even when the cell reads "Mon".

The cell in question is displaying "Mon", but it is a formula to copy another cell with a numbered date. Has anyone worked with an issue like this before?

I would so appreciate any insight at all.

 

[yesterdays]

May be this will help:
=VLOOKUP(A1,INDEX({"Mon",3;"Tue",3.75;"Wed",4.25;"Thu",3.75;"Fri",3.75;"Sat",0;"Sun",0},0,0),2,FALSE)

 

[disarae]

Thank you so much for responding!! I received this after copy/pasting your formula (and I changed the cell number):

#N/A

That's a new result for me. Do you have any idea what that means?

 

[yesterdays]

Could you show me the formula in cell displaying "Mon"?
The N/A mean the value of it are not actually "Mon"

 

[vcoolio]

Hello Disarae,

Just going back to your nested If formula: according to the formula, the week day entries (Mon,Tue, etc.) go into cell H12 and the required resultant values (3, 3.75, 4.25 etc.) should show in cell A1 but cell A1 shows "False" or "0" when H12 is empty. Is this correct?
If so, perhaps a slight amendment to your formula may solve this, as follows:-

=IF(H12="Mon",3,IF(H12="Tue",3.75,IF(H12="Wed",4.25,IF(H12="Thu",3.75,IF(H12="Fri",3.75,IF(H12="Sat",0,IF(H12="Sun",0,"")))))))

I'm not familiar with excel on a Mac but I would assume that there isn't too much difference.

I hope this helps.

Regards,
vcoolio.