Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Layered "If" statement.
I would like to know if someone could tell me how to do this. I have to check if a cell contains the letter M. If it does, then the word monday must be inserted into another cell. If it is not M, then it must check to see if it is a T for tuesday. This must continue, checking for w, th, and f. I have been trying something like this, but it doesnt work: {for, say L3} =if(H3=M,monday,(if(H3=T,tuesday,____________))) I skipped the ___________ Help? -- brookdale ------------------------------------------------------------------------ brookdale's Profile: http://www.excelforum.com/member.php...o&userid=24617 View this thread: http://www.excelforum.com/showthread...hreadid=382076 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) | |||
IF Statement | New Users to Excel | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |