NEED HELP WITH FORMULA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I really need some help. I am working on a spreadsheet, and I need to round up the numbers
For example, I have 9,481 in one column, and I multiply that with another column $225.00, and the total is $2,133,225.00. I need to round up so the total comes to $2,133.23
Can anyone help me
Thanks in advance
Jen
 
C1=ROUND((A1*B1/1000),2)
-----Original Message-----
Hi,
I really need some help. I am working on a spreadsheet,
Click to expand...
and I need to round up the numbers.
For example, I have 9,481 in one column, and I multiply
Click to expand...
that with another column $225.00, and the total is
$2,133,225.00. I need to round up so the total comes to
$2,133.23.
 
Have you tried
=C4*C5/1000

--
Don Guillett
SalesAid Software
(e-mail address removed)
Jen said:
Hi,
I really need some help. I am working on a spreadsheet, and I need to round up the numbers.
For example, I have 9,481 in one column, and I multiply that with another
Click to expand...
column $225.00, and the total is $2,133,225.00. I need to round up so the
total comes to $2,133.23.
 
Hi Jen!

Try:

Format > Cells > Custom

Type the following in the input box at the top:
$#,###,.00

Note especially that comma before the decimal point.

But note that this is formatting which only affects how the number is
displayed. Excel is still internally storing 2,133,225.00

If you want to alter the number stored, then divide by 1000 and use
the (probably default) currency format to get $2,133.00

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Jen said:
Hi,
I really need some help. I am working on a spreadsheet, and I need to round up the numbers.
For example, I have 9,481 in one column, and I multiply that with
Click to expand...
another column $225.00, and the total is $2,133,225.00. I need to
round up so the total comes to $2,133.23.
 
Assume you mean you want it turned into $K to 2 dps - With your numbers in A1
and A2

=ROUND(A1*A2,-1)/1000

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :-)
----------------------------------------------------------------------------



Jen said:
Hi,
I really need some help. I am working on a spreadsheet, and I need to round up the numbers.
For example, I have 9,481 in one column, and I multiply that with another
Click to expand...
column $225.00, and the total is $2,133,225.00. I need to round up so the total
comes to $2,133.23.
 
Back
Top