Equation for Networkdays that give negative number results

0

How do I write an equation in excel to calculate days AND if negative number results, leave the cell blank?

I have an equation to calculate the days, but I have black cells as information is continually being filled in. So instead of showing a negative number, I'd like it to be blank.

Thank you

Answer
Discuss

Answers

0

Please only post a question once (I went ahead a deleted the duplicate).

You need to surround the current function with an IF statement like this:

=IF((YOUR CURRENT FORMULA)<0,"",YOUR CURRENT FORMULA)

The quotation marks in there are double qyotation marks with nothing between them; if you want, you can put text to output in there too.

Discuss

Discussion

I can't get it to work...  This is what I have.  I just don't want a negative number due to data not being logged in. 
krichards Mar 20, '17 at 10:06 am
Edit your question and update it to include the formula and I can provide a more specific answer.
don (rep: 1322) Mar 20, '17 at 11:15 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login