iserror and conditional formulas

[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

 

[Guest]

=IF(ISNUMBER(Q7),MAX(72-Q7,0),"-")

 

[Guest]

Thank you very much

=IF(ISNUMBER(Q7),MAX(72-Q7,0),"-")