I want Excell to Calc based on Input Data

Closed
haggard - May 17, 2009 at 04:10 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 03:01 AM
Hello,

I want to be able to put in a number and then excel does a cal all in one cell.

I know I could put 6 in C3 then in D3 put =c3*178

but I want to know if there is a way for it to ask me for a number then I put in the number and it displays the calculation

2 responses

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 19, 2009 at 02:55 AM
Suppose you have two cells A2 & B2 now you can enter values in Cell A1 (3) & Cell B2 (5) and can make formula in Cell C2 = A2*B2 so your result will be 3x5 = 15 .... so no need to enter 178 manually in formula ......

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 19, 2009 at 03:01 AM
Suppose you have two cells A2 & B2 now you can enter values in Cell A1 (3) & Cell B2 (5) and can make formula in Cell C2 = A2*B2 so your result will be 3x5 = 15 .... so no need to enter 178 manually in formula ......