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? |
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? |
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? |
All times are GMT +1. The time now is 02:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com