Ifblank

Joined
May 25, 2012
Messages
2
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top