Formula to calculate discount percentage

Hello,

I need a formula to be able to calculate the discount percent between two amounts.

For example:

 

In column A I have a customer's regular price of $4.36

In column B I have the customer's discount price of $4.15

In column C I need a formula to calculate the discount percent between the two costs.

I know it should be around 5%, but can't figure out how to get there.

Any help would be appreciated.

Thank you

Answer
Answer

HI,

=1-(B1/A1)

format cell as %, the formula will give you a positive % if you want to see -5% use

=(B1/A1)-1

If this post is helpful or answers the question, please mark it so, thank you.

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated May 30, 2020 Views 7,321 Applies to: