| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make cell value zero if cell formula returns value less than zero?
Is there an easy way, such as a format setting, to make a cell value zero if
the cell's formula returns a value less than zero? I've used a conditional statement with the SIGN function before, but I have existing cells with formulas that I would just like to apply a format to if possible. =IF(SIGN(+L7+N7+P7-K7)=-1,0,+L7+N7+P7-K7) Thank you, Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for a cell which is blank returns populated cell | Excel Discussion (Misc queries) | |||
| Cell reference in formula always returns a zero value | Excel Discussion (Misc queries) | |||
| Formula returns cell name | Excel Discussion (Misc queries) | |||
| Formula returns cell name | Excel Discussion (Misc queries) | |||
| Formula to sum every 4th cell returns #DIV/0! error in some column | Excel Worksheet Functions | |||
![Fred Ernst[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
