| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Multiple IF conditions
I give up! How can I convert the following 1-2-3 formula for my Excel sheet:
@IF(EH10<""#AND#EF10<""#AND#EH10-EF10<.0001,1,"") I'm thinking I need multiple AND statements, but can't get it to work. Any help at all would be appreciated. |
|
#2
|
|||
|
|||
|
=if(and(EH10<"",EF10<"",EH10-EF10<.0001),1,"")
"mckzach" wrote: I give up! How can I convert the following 1-2-3 formula for my Excel sheet: @IF(EH10<""#AND#EF10<""#AND#EH10-EF10<.0001,1,"") I'm thinking I need multiple AND statements, but can't get it to work. Any help at all would be appreciated. |
|
#3
|
|||
|
|||
|
You need IF(AND(EH10<"",EF10<"",EH10-EF10<.0001),1,"") mckzach Wrote: I give up! How can I convert the following 1-2-3 formula for my Excel sheet: @IF(EH10<""#AND#EF10<""#AND#EH10-EF10<.0001,1,"") I'm thinking I need multiple AND statements, but can't get it to work. Any help at all would be appreciated. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=470031 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup with multiple conditions | Excel Discussion (Misc queries) | |||
| Vlookup with multiple conditions | Excel Worksheet Functions | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Hybrid Mode
