The following formula returns the #Value! message:

=IF(72-Q70,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-Q70,0),"-",72-Q70,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

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

"Skibee" wrote:

The following formula returns the #Value! message:

=IF(72-Q70,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-Q70,0),"-",72-Q70,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

Thank you very much

"Toppers" wrote:

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

"Skibee" wrote:

The following formula returns the #Value! message:

=IF(72-Q70,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-Q70,0),"-",72-Q70,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