|
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. |
=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. |
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 |
| All times are GMT +1. The time now is 11:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com