| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional format to show 0 value
I am treing to show 0 if the sum is less than 1000 instead of a negative Number
Can anyone help me? |
|
#2
|
|||
|
|||
|
Whatever your formula currently is that you don't to return anything greater
than 0, try =MIN(0,your_formula) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Raymond Monk" <Raymond wrote in message ... I am treing to show 0 if the sum is less than 1000 instead of a negative Number Can anyone help me? |
|
#3
|
|||
|
|||
|
Thank you I will try that
"Ken Wright" wrote: Whatever your formula currently is that you don't to return anything greater than 0, try =MIN(0,your_formula) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Raymond Monk" <Raymond wrote in message ... I am treing to show 0 if the sum is less than 1000 instead of a negative Number Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format of data tables in charts | Charts and Charting in Excel | |||
| How can I conditional format to show either a percentage or a whol | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| make a conditional format the default | Excel Discussion (Misc queries) | |||
| Copying a conditional format | Excel Worksheet Functions | |||
Linear Mode
