Hi,
A colleague of mine is trying to get a formula working in excel. It reads in various cells. Occassionally, one of these cells is a blank and this throws a '####' error.
We tried using =IF(ISBLANK(G9),0,G9 which didn't work then we tried =IF(OR(AND(G1>-100000,G1<0), AND(G1>0,G1<100000)),G1,0) which then seemed to return a value of 0 whether there was a value in G1 or not.
Any ideas?
A colleague of mine is trying to get a formula working in excel. It reads in various cells. Occassionally, one of these cells is a blank and this throws a '####' error.
We tried using =IF(ISBLANK(G9),0,G9 which didn't work then we tried =IF(OR(AND(G1>-100000,G1<0), AND(G1>0,G1<100000)),G1,0) which then seemed to return a value of 0 whether there was a value in G1 or not.
Any ideas?