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 ......

0
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 ......

0