I have a blank cell, and I was to take the dollar amount from another cell, multiply it by a percent, and place the result in this blank cell.
So if I, for example, have a sum of 642.00 in cell A1, and I want to do a calculation of 642*9.95%, and put that result in cell b3, how would I do that? I have tried a number of ways, but I cannot find a way to do that.
So any help, information, or suggestions would be really appreciated. Thank You.
Just type to cell B3 =A1*9.95% and press Enter. Calc will replaced it to =A1*0.0995 and result will be 63.879. Select this cell and press Ctrl+Shift+4 (apply Currency format). Final result is $63.88
Like this
Thanx, but it didn’t work. I tried what you suggested, and all I got in both cells was something that said Error 522. But I appreciate the help.
In both cells?!.. You said that in cell A1 you have the number 642. Well, please wait a few minutes, I will try to supplement my answer.
Just do what the Calc function% would do for you: instead of wanting 9,95% you want 0,0995(no %!).
It is just maths
That was a wonderful graphic you created for me, and I really do appreciate all the effort it took to create. But trying what you said still produced the Error 522. maybe I left something out. I have a dollar figure in K55. I want to multiply that number by 9.95%, and put the result in Q53. But when I try what you suggest, I get that Error 522 in all 3 cells.
Am I trying to do something that cannot be done? If it cannot be done, then oh well. But thanks for all your input and help in this.
Error 522 is “Circular reference” - Formula refers directly or indirectly to itself… You say that K55 have a dollar figure - not formula, just digital value? OK. Go to Q53, type =K55*9.95% and press Enter. It must work!