Gross Profit Percentage

[beaudroix]

I am trying to enter cost and sell price and the outcome be the gross profit percentage I am making.

A1 = $100 (Cost)
B1 = $150 (Sell)
C1 = 33.33%

the formula I am entering =sum(A1/B1)-1 is giving me a negative -33.33%

how can I get this to display a postive 33.33%????

thank you for your help!!!

[haru]

=1-(a1/b1)

[beaudroix]

haru, THATS IT! Thank you so much!!!