# Twice percentage cell

1. ## Twice percentage cell

It has been a while since math, so I am having trouble.

Say the cell I am referencing value is 100,000

I need to take two percentages off of that number. First 50%, then 37% and have the value in a SINGLE cell.

Because 100,000/1.87 is not the same thing....of course.  Register To Reply

2. ## Re: Twice percentage cell

=100000-100000*0.5-(100000-100000*0.5)*0.37
I think?  Register To Reply

3. ## Re: Twice percentage cell

=(a1*0.5)*0.63  Register To Reply

4. ## Re: Twice percentage cell

I am going to try both...lol...but they look good  Register To Reply

5. ## Re: Twice percentage cell

Both gave me the same number. The ACTUAL number I am referencing is \$121,755.

How I calculate it out is....121,755/1.5= 81,170 THEN 81,170/1.37 = 59,248....I need the 59248

Both formulas gave me 38,353.

What i am trying to do is boil a 50% markup from 121,755 down to 81,170 then 37% markup from 81,170 down to 59248  Register To Reply

6. ## Re: Twice percentage cell

=(121755/1.5)/1.37  Register To Reply

7. ## Re: Twice percentage cell

It's probably more of an arithmetic question than just Excel, but:

y=(x/1.5)/1.37=x/(1.5*1.37)=x/2.055 In excel, this could be =A1/1.5/1.37 or =A1/2.055 or =A1/(1.5*1.37). If you wanted to put the markups into cells so they could be edited later, then replace the constants with appropriate references.  Register To Reply

8. ## Re: Twice percentage cell  Register To Reply

9. ## Re: Twice percentage cell

I really am retarded.....This is depressing  Register To Reply

10. ## Re: Twice percentage cell

Cross-posting is not necessarily bad. We just want to know when and where you have cross-posted (the rules ask you to provide the link) so that we don't waste our time/effort helping to solve a problem here that has already been solved elsewhere.  Register To Reply

11. ## Re: Twice percentage cell

tnx..never knew  Register To Reply

12. ## Re: Twice percentage cell

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -

Incase your issue is not solved, you can undo it as follows -

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.  Register To Reply