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
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