# Thread: Multiple If depending on date Thanks: 0 Likes: 0

1. ## Multiple If depending on date

How do i get a cell to look at a cell and depending on the date divide another cell by a certain number?

for example:

In cell H44 I want it to look at H6 and if that date is within the dates of the first quarter then divide whats in H35 by 520, if the dates are with second quarter it divided by 1040 and so forth.

Thank you

2. ## Re: Multiple If depending on date

Try:

=H35/(INT((MONTH(H6)+2)/3)*520)

3. ## Re: Multiple If depending on date

How about
=H35/(ROUNDUP(MONTH(H6)/3,0)*520)

4. ## Re: Multiple If depending on date

Originally Posted by Fluff
How about
=H35/(ROUNDUP(MONTH(H6)/3,0)*520)
How would I get this into a multiple if statement to say if second qtr then divide by 1040if third qtr divide by 1560 and fourth qtr by 2080

5. ## Re: Multiple If depending on date

It already does that, as does Eric's

6. ## Re: Multiple If depending on date

Both of our formulas figure out what quarter it is, based on the month of the date in H6. Months 1,2,3 --> quarter 1, months 4,5,6 --> quarter 2, etc. Then we take the quarter number and multiply by 520, which give 520, or 1040, or 1560, or 2080. So we don't really need an IF in this case.

7. ## Re: Multiple If depending on date

Sorry, yes It does. Thanks

8. ## Re: Multiple If depending on date

Glad we could help & thanks for the feedback

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•