Help Editing Formula

[Charlie]

Hi, I need help editing this formula =IF(OR(D9={"Paid in Full","Underpaid"}),0%,$E$3)the new formula has gotta add $E$4 representing a rise of 3% for Feb the $E$3 is 6% Jan, in short it has gotta change the data in the resulting column depending on whether the month is Jan or Feb.The column with Months in it is B8.
Thanks
This message was edited by Charlie on 2002-03-28 15:09

 

[Aladin Akyurek]

On 2002-03-28 15:55, Charlie wrote:
Yes the data is to appear in the Percentages column.
Charlie

And, in which cell is the first occurrence of January? Is "January" a true date or just entered as text?

You said E3 has the % for January, and E4 % for February. Do you also have % for March etc in E5 etc.?

 

[Charlie]

The Months are entered as just text,they start in B8,and I only have 6% in E3 and 3% in E4, no other months are entered.

 

[Charlie]

Got it, relax, my fault.Dumb I know but I made a spelling error in February would you believe.Guess I have ben at it too long tonight and its a little late.
sorry to be a pest.
Thanks Charlie.

 

[Aladin Akyurek]

On 2002-03-28 16:09, Charlie wrote:
The Months are entered as just text,they start in B8,and I only have 6% in E3 and 3% in E4, no other months are entered.

OK, Charlie.

In E8 enter and copy down:

=IF(OR(D8={"Paid in Full","Underpaid"}),0%,(B8="January")*$E$3+(B8="February")*$E$4)

Aladin