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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting IF's and AND's - a bit of help please...
I think you've confused everyone with this expression:
1/1/1 As it's written in your formula, it evaluates to: 1 divided by 1 divided by 1 Which equals 1. Is that really what you had in mind? -- Biff Microsoft Excel MVP "neilcarden" wrote in message ... 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. -- neilcarden |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting IF's and AND's - a bit of help please...
Hi,
Try this: =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",""))) "neilcarden" wrote: 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. -- neilcarden |
Reply |
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) |