#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default formula

I need to know a formula that gets me a % of a figure of 25.00 marked up to
35.00.
Can anyone help?
--
Deborah Motte
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default formula

=(35-25)/25 and format as percentage
--
Gary''s Student - gsnu200838
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default formula

I think you're wanting:
=(35-A2)/A2
Format cell as percentage.

Formula claculates how much of a percentage of orginal price it is to mark
the price up to 35. If this isn't what you were looking for, perhaps you
could prvide an example showing what you want done.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"workingwoman" wrote:

I need to know a formula that gets me a % of a figure of 25.00 marked up to
35.00.
Can anyone help?
--
Deborah Motte

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"