Forum Discussion
Formula Help for Cells
I want to create a formula in a column where i can input a number and it would automatically multiply and calculates the answer. For example, the amount to calculate would be $50. I would type 5 i...
If in A1 is 50, in B1 is 5 and in C1 = A1*B1 you have desired result.
If in A1 is 50, you enter in in A1 5 and would like to have 250 in A1, that is VBA programming. But in any case not reliable solution. Assume you mistakenly enter 4, result it 200. You change on 5 on have now 1000.