I tried to put in the B1 formula for my margin %, but I keep getting an error message. Also, how do I put in my numbers in the "1" columns when I have to put my categories in that position. In other words I can't start with A1, I have to start with A2??
C1 =A1*(1+B1)
D1 =C1-A1
E1 =D1/C1
If you enter your wholesale price and gross margin %, then:
B1 =((A1*(1/(1-E1)))/A1)-1
C1 =A1*(1+B1)
D1 =C1-A1
<!-- / message -->
C1 =A1*(1+B1)
D1 =C1-A1
E1 =D1/C1
If you enter your wholesale price and gross margin %, then:
B1 =((A1*(1/(1-E1)))/A1)-1
C1 =A1*(1+B1)
D1 =C1-A1
<!-- / message -->
