# Excel

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.

1. 👍
2. 👎
3. 👁
4. ℹ️
5. 🚩
1. You probably will need to write an IF statement.

1. 👍
2. 👎
3. ℹ️
4. 🚩
2. That is, IF the answer is negative, add 365; otherwise, calculate regularly.

1. 👍
2. 👎
3. ℹ️
4. 🚩
3. Yeah but I can't figure out how to do that, how do I do an IF function within the calculation?

1. 👍
2. 👎
3. ℹ️
4. 🚩
4. Go to the help part of Excel and type in if statement. It will give you instructions.

1. 👍
2. 👎
3. ℹ️
4. 🚩

## Similar Questions

1. ### Career Planning

Which of the following defines a short-term goal? A.tasks that you set to accomplish specific things in a short period of time****** B. tasks that must be completed for a job performance evaluation C. tasks that you must complete

2. ### Finance

An insurance company is offering a new policy to its customers. Typically, the policy is bought by a parent or grandparent for a child at the child's birth. The details of the policy are as follows: The purchaser (say, the parent)

3. ### Mental & Emotional Health

1.)True & False Life changes, whether they are positive or negative, can cause stress True or False 2.)Making a list of what you have to do & identifying what is most is an example of ? A.)Mental rehearsal of tasks B.)Relaxing by

4. ### Math

On his 12th birthday Enoch's grandparent's deposited \$25 into a savings account for him. Each month after that up to and including his 20th birthday, they deposit \$10 more than the previous month. How much money will Enoch have on

1. ### Composition

Revise the following paragraph, improving it without changing its overall meaning. Pay particular attention to sentence structure. Ever been assigned to work on a group project for class! Many students dread group projects:

2. ### Math

Use a ruler to create a 6" x 8" rectangle. Cut rectangle on a diagonal. Use the two triangles to create four new shapes. List the most specific shape and its perimeter

3. ### Math

Julia spent 1/3 of her birthday money and she lost half of the rest now she has \$10 left how much did she get for her birthday

4. ### MATH, HELP

what is the probability that at least 2 students in a class of 36 have the same birthday? Do i punch this in to the calculator or how did you found this way or method for your solution: Log(365!) = 1792.3316 Log(329!) = 1581.7202

1. ### college math

Assume that there are 16 board members: 10 females, and 6 males including Larry. There are 4 tasks to be assigned. Note that assigning the same people different tasks constitutes a different assignment. (1) Find the probability

2. ### English

What is the part of speech of "for my birthday" in each sentence? An adverb phrase or an adjective phrase? Would you check them, please? Can a phrase be either an adjective phrase or an adverbial phrase? Thank you. 1. What do I

3. ### history

I need to someone to write a timeline for me. Assignment Recall that the project requires you to create a timeline that identifies significant events of the Renaissance and Protestant Reformation. Your assignment is to identify at

4. ### Math

Julia spent 1/3 of her birthday money. Then she lost 1/2 of the rest. She now has \$10.00 dollars left.how much did she get for her birthday.