Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formulas | New Users to Excel | |||
Iserror nested within a conditional vlookup | Excel Worksheet Functions | |||
Conditional use of formulas | Excel Worksheet Functions | |||
Conditional Formulas | Excel Worksheet Functions | |||
conditional formulas | Excel Worksheet Functions |