Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 13th 09, 02:49 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default help with formula - newbie

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



  #2   Report Post  
Old May 13th 09, 03:41 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
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


  #3   Report Post  
Old May 13th 09, 04:15 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default help with formula - newbie

Wow, thanks for the fast response. I was putting brackets in between the
elements.

But I'm sorry to say I forgot one element. The beginning figure (say in A1)
has to have 50,000.00 subtracted from it before all the rest of the stuff
happens. I just tried to add it to the formula but obviously I put it in the
wrong place, because, no go.

Do you have time to try one bit more?

Thanks so much.

Diane



"JoeU2004" wrote in message
...
"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




  #4   Report Post  
Old May 13th 09, 05:25 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default help with formula - newbie

"DianeI" wrote:
But I'm sorry to say I forgot one element. The
beginning figure (say in A1) has to have 50,000.00
subtracted from it before all the rest of the stuff happens.


In your original example, you used an "initial" value of $456,789.89. If
you now mean that the initial value is really 506,789.89, then:

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


I just tried to add it to the formula but obviously
I put it in the wrong place, because, no go.


For future reference, it is best to post the formula that you tried. First,
it avoids our making the same mistakes due misunderstandings. Second, you
might get two lessons for the price of one: the answer to your question,
and an explanation of where you went wrong.


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

"DianeI" wrote in message
...
Wow, thanks for the fast response. I was putting brackets in between the
elements.

But I'm sorry to say I forgot one element. The beginning figure (say in
A1) has to have 50,000.00 subtracted from it before all the rest of the
stuff happens. I just tried to add it to the formula but obviously I put
it in the wrong place, because, no go.

Do you have time to try one bit more?

Thanks so much.

Diane



"JoeU2004" wrote in message
...
"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





  #5   Report Post  
Old May 13th 09, 06:47 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default help with formula - newbie

Thanks so much for your patience and help. I'll try to follow group
procedure next time I write in as I see it's way more organized that way.

Your solution works great and I'm grateful. I'd bake you a cake......

Thanks again.

Diane


"JoeU2004" wrote in message
...
"DianeI" wrote:
But I'm sorry to say I forgot one element. The
beginning figure (say in A1) has to have 50,000.00
subtracted from it before all the rest of the stuff happens.


In your original example, you used an "initial" value of $456,789.89. If
you now mean that the initial value is really 506,789.89, then:

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


I just tried to add it to the formula but obviously
I put it in the wrong place, because, no go.


For future reference, it is best to post the formula that you tried.
First, it avoids our making the same mistakes due misunderstandings.
Second, you might get two lessons for the price of one: the answer to
your question, and an explanation of where you went wrong.


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

"DianeI" wrote in message
...
Wow, thanks for the fast response. I was putting brackets in between the
elements.

But I'm sorry to say I forgot one element. The beginning figure (say in
A1) has to have 50,000.00 subtracted from it before all the rest of the
stuff happens. I just tried to add it to the formula but obviously I put
it in the wrong place, because, no go.

Do you have time to try one bit more?

Thanks so much.

Diane



"JoeU2004" wrote in message
...
"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









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


Similar Threads
Thread Thread Starter Forum Replies Last Post
I'm a Newbie, Need Formula Natalie John Excel Discussion (Misc queries) 5 August 10th 08 12:35 AM
Real Newbie newbie question Dave New Users to Excel 0 January 10th 07 08:55 PM
formula series (newbie) Sam Excel Worksheet Functions 3 January 7th 07 09:02 PM
Newbie problem need formula help toddbob Excel Worksheet Functions 3 April 3rd 06 06:24 PM
Newbie needs help deciphering formula. Grimzby Excel Worksheet Functions 2 January 17th 06 04:46 AM


All times are GMT +1. The time now is 01:56 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017