Wholesale vs Retail

New Contributor

I need to add 25% to my wholesale to have my retail price.  How do I do that (C column is Wholesale and D column is Retail)?  Thank you in advance

3 Replies
best response confirmed by Hans Vogelaar (MVP)


Presuming sample data in C2:C9, try this one:







If you're not on Excel 2021 or 365, then do this one and fill down:






Beautiful thanks so much.
You are welcome! Glad I could help.