MrExcel Publishing
Your One Stop for Excel Tips & Solutions

On Enter Keypress


Posted by Jim on July 03, 2001 11:45 AM

Is it possible to have a number in A1 while B1 is empty,
then after entering a number in B1 hit the Enter Key
and have it multiply B1 by A1?
Any help or thoughts would be appreciated.
Jim


Posted by Russell on July 03, 2001 2:33 PM

Yes. In C1, put the formula =A1*B1. I don't think there's a way to put the result into B1.