Hi, I'm having problems getting a formula to work.
It is>
=IF(I2=J2,I2+1,IF(AND(I2>0,ISNA(J2)),I2+1,IF(AND(ISNA(I2),J2>0),J2+1,"none")))
The first part is working fine, if I2 and J2 are the same, I am getting I2+1, if not, i'm getting #N/A. For some background, if there are numbers in both I2 and J2 they will always be the same, if there is no number, there will be #N/A (caused by another formula), if there is a number it will always be higher than 0.
Thanks in advance for your help, I've scratching my head over this all morning, and I know i'm probably just doing something stupid...
Cheers
Elliott
Bookmarks