Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

exceldate-timeformulas-functions
MS Office Version: 2013
posted by: krichards on Fri Mar 17, 2017 at 4:10 pm
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.

posted by: don (rep: 1989) on Sat Mar 18, 2017 at 12:18 am
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: 1989) 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