Asked by Amanda
I have an assignment where I have to create a birthday list. One of the tasks is to add a countdown til someone's birthday, I have the formula as:
=DAYS360($D$200,I3)
However how do I calculate it so if some's birthday past I can recalculate it so it is not negative.
Like if someone's birthday past it will say -105 days, where I want to add 365 to any negative amounts.
=DAYS360($D$200,I3)
However how do I calculate it so if some's birthday past I can recalculate it so it is not negative.
Like if someone's birthday past it will say -105 days, where I want to add 365 to any negative amounts.
Answers
Answered by
DrBob222
You probably will need to write an IF statement.
Answered by
DrBob222
That is, IF the answer is negative, add 365; otherwise, calculate regularly.
Answered by
Amanda
Yeah but I can't figure out how to do that, how do I do an IF function within the calculation?
Answered by
DrBob222
Go to the help part of Excel and type in if statement. It will give you instructions.
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.