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
=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