iserror and conditional formulas


G

Guest

The following formula returns the #Value! message:

=IF(72-Q7>0,72-Q7,0)

(Note Q7 is currently blank, it will be populated as commodity movements
occur. Once populated, it could return numbers ranging from -3 to 3. I only
want the positive numbers to display, otherwise a 0 needs to be returned.)

I have tried to correct this using:

=IF(ISERROR(72-Q7>0,0),"-",72-Q7>0,0) but I receive a message that there is
an error in the formula. I have tried playing around with it a bit but
cannot work out how to fix it.

Instead of #Value!, I would like a dash to appear.
Help gratefully received.
Liz
 
Ad

Advertisements

Ad

Advertisements


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