FUNCTION FOR MARK-UP?????????

  • Thread starter Thread starter KIMBERLY
  • Start date Start date
K

KIMBERLY

I WOULD LIKE TO PUT A FUNCTION IN TO DO 35 MU LIKE ON A CALCULATOR...


EX: 33,180- DIVIDED BY 35 MU = 51,046.15

CELL A1 33,180
CELL A2 35 MU??? (WHATEVER THE CORRECT FORMULA IS)
CELL A3 =A1/A2

DOES ANYONE KNOW HOW TO DO THIS MARK-UP FUNCTION?

PLEASE HELP!!!!!!!THANK YOU SOOOOO MUCH
 
Please don't post in all caps! It's hard to read and is considered rude.

Cell A2:
35%

Cell A3:
=A1/(1-A2)

BTW, the 35% is the margin; not the markup. The markup would be:

=(A1-A3)/A1

or 54%.
 
Back
Top