# Excel

posted by .

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.

• Excel -

You probably will need to write an IF statement.

• Excel -

That is, IF the answer is negative, add 365; otherwise, calculate regularly.

• Excel -

Yeah but I can't figure out how to do that, how do I do an IF function within the calculation?

• Excel -

Go to the help part of Excel and type in if statement. It will give you instructions.

## Similar Questions

1. ### Today is my.......

Today is my birthday! I wonder what is my HOROSCOPE SIGN?
2. ### MATH, HELP

what is the probability that at least 2 students in a class of 36 have the same birthday?
3. ### math

Chris received \$1 on his first birthday,\$3 on his second birthday,\$6 on his third birthday,\$10 on his four birthday.How much money will Chris receive on his eighth birthday if the pattern continues?
4. ### math

John receives \$200 for his birthday. He buys 4 DVDs at \$12.95 each. Sales tax is 6.25%. How much birthday money does he have left?
5. ### math

1. First of all, pick the number of times a week that you eat chocolate. This number must be more than one but less than ten. 2. Multiply this number by 2 (just to be bold). 3. Add 5 (for Sunday). 4. Multiply it by 50. 5. Add 1750. …
6. ### English

Hi Miss Sue, Here is the final draft can you check it for me?
7. ### Math

Ok so in class this is what our teacher had us do.... 1.Pick a number to represent the number of times you would like to have chocolate in a week (more than once, but less than 10 times). 2.Double this amount (just to be bold). 3.Add …
8. ### English

One more question related to 'for' goes as follows. Thank you for your explanation. 11. The nice gift for my birthday was a dictionary. 12. A nice gift for my birthday was a dictionary. (Q1: Do we have to use 'the' or 'a' before 'nice …
9. ### English

What is the part of speech of "for my birthday" in each sentence?
10. ### English

1. Today is my birthday. One of my family members knew that. I have a sister. She gave me a watch for my birthday. (Is this passage grammatical?

More Similar Questions