Using IF Functions with multiple variables and ranges

[redgummers]

Hi,

I am trying to create an IF fucntion that when a cell is a number it will input a value that is that number in question + 1, however the cell that is referenced also contains - and letters to represnts alpha and numeric revisions of a document.

Currently I have tried the follow code:
=IF(11>AA3>=0,AA3+1,IF(AA3="A",0,IF(AA3="B",0,IF(AA3="C",0,IF(AA3="D",0,IF(AA3="E",0,IF(AA3="-",0,0)))))))

However this ends up in an "VALUE#!" error. What would be the best way to say, if the cell (AA3) is A,B,C,D,E,F or - then = 0 while if the cell (AA3) is 0,1,2,3,4 etc. then = that number + 1?

Any help would be greatly appreciated.

Thanks,
Nick

[benishiryo]

hi Nick, welcome to the forum. if there are only 2 scenarios possible (Letters/"-" OR numbers), try:
=IF(ISNUMBER(AA3),AA3+1,0)

if there are other possibilities, and you need something more specific like you mentioned then:
=IF(OR(AA3="-",AND(CODE(UPPER(AA3))>=65,CODE(UPPER(AA3))<=70)),0,IF(AND(AA3>=0,AA3<=4),AA3+1,""))

[redgummers]

Thanks for your help, the first formulae looks to be the one I was chasing.