Formula to have data populated when entered in different cells - IF THEN?

[ahblur]

Hi,

I am trying to use an IF THEN formula for what I am looking for.

Cost Revised Cost %
100 150 50%
400 450 13%

There is Cost (column A), and I want to be able to have the Revised Cost (column B) and % (column C) populate automatically if data is entered in either cell B or C.

Example, if I enter 200 in cell B, the % would populate automatically. If I enter 20% in cell C, the number will populate automatically under cell B.

I thought I should be using IF THEN but for some reason, I couldn't get the result.

Any help that you can advise is much appreciated.

Thank you.

[Pepe Le Mokko]

I'm afraid you'll need VBA for this. You cannot enter a formula where you expect the result of another