Home 
Search 
Today's Posts 
#1




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




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




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




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(A150000,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




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(A150000,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 
Display Modes  


Similar Threads  
Thread  Forum  
I'm a Newbie, Need Formula  Excel Discussion (Misc queries)  
Real Newbie newbie question  New Users to Excel  
formula series (newbie)  Excel Worksheet Functions  
Newbie problem need formula help  Excel Worksheet Functions  
Newbie needs help deciphering formula.  Excel Worksheet Functions 