View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default help with formula - newbie

"DianeI" wrote:
It needs to be rounded up to the next thousand [...] then made into
thousands (457)
then multiplied by $14.00 per thousand (457 x 14)
then the result added to $358.00


=roundup(A1,-3)/1000*14+358


----- original message -----

"DianeI" wrote in message
...
New job and I need to make a formula for a calculation I do several times
a
day I am getting very bored with using a calculator first then typing the
result into my spreadsheet. No one else at work needs to do this or knows
how to do it better.

I start with an amount which is always over $50,000.00 (and up to
100,000,000.00)
It needs to be rounded up to the next thousand such as $456,789.89 to
$457,000 (roundup,-3)
then made into thousands (457)
then multiplied by $14.00 per thousand (457 x 14)
then the result added to $358.00

I can make excel do each part but when I put them together, chaos

thanks for any help you can offer

Diane