Ask Your Question

How do I make a calculation using percents

asked 2017-10-23 15:01:39 +0200

peterct gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-10-23 15:11:14 +0200

JohnSUN gravatar image

updated 2017-10-23 19:41:00 +0200

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


edit flag offensive delete link more


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.

peterct gravatar imagepeterct ( 2017-10-23 18:44:27 +0200 )edit

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.

JohnSUN gravatar imageJohnSUN ( 2017-10-23 19:28:44 +0200 )edit

Just do what the Calc function% would do for you: instead of wanting 9,95% you want 0,0995(no %!). It is just maths

Henk C. Meerhof gravatar imageHenk C. Meerhof ( 2017-10-24 11:38:59 +0200 )edit

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.

peterct gravatar imagepeterct ( 2017-10-24 12:49:45 +0200 )edit

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!

JohnSUN gravatar imageJohnSUN ( 2017-10-24 17:45:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-23 15:01:39 +0200

Seen: 159 times

Last updated: Oct 23 '17