James Irwin

hi - i'm trying to use the isblank formula to return "1" if the referenced
cell is blank and "2" if not. However, the cells i'm referencing are all
formulae, so the isblank function returns "2" even if the cell "looks" blank
(i.e. "" has been used in a formula so cell text is blank but formula is
picked up by 'isblank'). So basically, i'm either i) looking for an
alternative to 'isblank' which only looks at the results/values of the cell
output or ii) looking for a way to make 'isblank' work with my reference
cells by changing the reference cells somehow (e.g. similar function to the
trim function)???

many thanks in advance.

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