MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with formula


Posted by Patrick on May 06, 2001 8:07 PM

I have these two formulas...that don't work


=IF(B4=36983,"",IF(ISNUMBER(A32),+A32+1,""))
+IF(B4=37044,"",IF(ISNUMBER(A32),+A32+1,""))
+IF(B4=37136,"",IF(ISNUMBER(A32),+A32+1,""))
+IF(B4=37197,"",IF(ISNUMBER(A32),+A32+1,""))

=IF(B4=36983,37044,37136,37197,"",IF(ISNUMBER(A32),+A32+1,""))

can anyone give a suggestion....please


Posted by Kevin James on May 06, 2001 9:30 PM

Patrick,

In both instances, the section: "+A32+1" you have an unnecessary plus (+) sign before A32. I think they call they Polish notation??? It is not needed in Excel.

Posted by Dave Hawley on May 06, 2001 9:32 PM


Hi Patrick

Try this:

=IF(OR(B4=36983,B4=37044,B4=37163,B4=37197,NOT(ISNUMBER(A32))),"",A32+1)

Dave


OzGrid Business Applications

Posted by Aladin Akyurek on May 06, 2001 11:39 PM

Patrick

All can be stated a bit shorter. Try:

=IF(AND(ISNUMBER(A32),OR(B4={36983,37044,37136,37197})),A32+1,"")

Aladin

Posted by Patrick on May 06, 2001 11:40 PM

Thanks again!!

works great...