Problem with a logic/date formula

D

Dudley

I gave three columns, A,B,C
In A are values such as $10000, in B are dates from 1/1/04 to 8/31/04

I need to calculate and amount in C based upon the following condition:
If B2 is less than 3/1/04, calculate A2*0.07, if B2 is greater than 8/1/04
calculate 0.08*A2 . If the date falls between 3/1/04 and 8/1/04, then
A2*0.0575.

I have tried to construct a nested IF to do this, but it does not work.

Any help will be greatly appreciated.

Dudley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top