Auto calculate on entering a figure

**tony0710** · 06-20-2010, 02:22 PM

Hi

I would like to have a macro or something running in the background of my spreadsheet so that when I enter the letter "c" in Cell B4 it becomes active and runs a formula - (B2*7)/47 - and places the result in cell B4, by removing the letter "c". This is to be done as I type the info in.

So, basically as I type the letter "c" in B4 - excel automatically calculates (B2*7)/47 and replaces "c" in B4 with the result of the calculation.

This is only to happen if the letter "c" is typed into B4 - it should not run if any other character/figure is typed into B4 - in fact if another character/figure is typed, then that character/figure should stay in B4.

Is this possible?

All help appreciated, as always.

**shg** · 06-20-2010, 04:04 PM

Why not just use a formula in another cell?

=if(b4 = "c", 7*b2/47, "")

**tony0710** · 06-20-2010, 04:23 PM

Hi Shg

I thought of that - but just didn't want to add another column.

Then again if this is the only way - then perhaps =If(B4="c",((B2*7)/47),B4) will work I assume. Will just have to alter the spreadsheet a bit.