View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default URGENT - percentage calculation

On Aug 8, 8:24 pm, Jack wrote:
I would like to make $250, 90% of $300. This will not make sense
to alot of you because as a percentage


Y'think? ;-)

Is there someway or formula in excel which will allow me to make,
or let excel think that $250 really is 90% of $300?


The formula can be as arbitrarily complex or simplistic as you want.
But on the off-chance that you simply are doing a poor job of
explaining what you want, the following formula rounds down to
multiples of 50:

=50 * rounddown(300*90%/50,0)