| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can not seem to get my IF / AND statement to work, help please
This is my IF / AND statement that I can not get to work.
(=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3))),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))). Does any one have any suggestions to what I am doing incorrectly? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My IF statement won't work for my formula | Excel Worksheet Functions | |||
| How do I get an IS and IF statement to work together in excel? | Excel Worksheet Functions | |||
| Anyone actually get Case statement to work ... ? | Excel Worksheet Functions | |||
| Why doesn't this nested IF statement work? | Excel Worksheet Functions | |||
| Array If statement doesn't work | Excel Worksheet Functions | |||
Threaded Mode
