I want Excell to Calc based on Input Data [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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 ......

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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 ......

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!