| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nesting IF's and AND's - a bit of help please...
Hi. I have 3 formula's which I would like merging into one?
=IF(AND(C3<$B$1,C31/1/1,D3=""),"N","") =IF(AND(C3$B$1,D3=""),"M","") =IF(AND(C31/1/1,D31/1/1),"Y","") I would like all these as one formula in cell E3? I've had a try myself but am not very good at nesting functions.... Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF's & AND's | Excel Discussion (Misc queries) | |||
| Too Many If's | Excel Worksheet Functions | |||
| IF's | Excel Worksheet Functions | |||
| SUMPRODUCT with AND's and OR's? | Excel Worksheet Functions | |||
| How many 'if's'? | Excel Discussion (Misc queries) | |||
Threaded Mode
