Do not show negative numbers

G

Guest

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?
 
C

CLR

Maybe....

=IF(COUNT(O235,R235)=2,DAYS360(O235,R235),"")

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average formula 1
Why do I get a #value error when doing the 360days formula? 3
negative dates 3
Microsoft Query is changing a negative number into a date 1
Eliminate negative numbers from stats 4
ignore value when a negative. 3
showing negative numbers 2
Negative numbers in Excel Invoice 4

Top