| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do not show negative numbers
I have this formula in cell S: =DAYS360(O235,R235).
When O has a date and R does not it is giving me -38138. I do not want a negative number to appear, as this throws off the average days formula I have elsewhere. It may be a couple days before a date is added to R. What do I need to do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not show negative numbers
Maybe....
=IF(COUNT(O235,R235)=2,DAYS360(O235,R235),"") Vaya con Dios, Chuck, CABGx3 "roy.okinawa" wrote in message ... I have this formula in cell S: =DAYS360(O235,R235). When O has a date and R does not it is giving me -38138. I do not want a negative number to appear, as this throws off the average days formula I have elsewhere. It may be a couple days before a date is added to R. What do I need to do? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not show negative numbers
That did it.
Thanks. "CLR" wrote: Maybe.... =IF(COUNT(O235,R235)=2,DAYS360(O235,R235),"") Vaya con Dios, Chuck, CABGx3 "roy.okinawa" wrote in message ... I have this formula in cell S: =DAYS360(O235,R235). When O has a date and R does not it is giving me -38138. I do not want a negative number to appear, as this throws off the average days formula I have elsewhere. It may be a couple days before a date is added to R. What do I need to do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| Can I calculate negative numbers to = zero in excel? | Excel Discussion (Misc queries) | |||
| How do I stop SUM commands going into negative numbers, i.e. roun. | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
Hybrid Mode
