How do I calculate without decimals in excel?

G

Guest

I'm working on a spreadsheet where certain columns are to be rounded to the
nearest whole number, while the answer is to be in currency. Excel is
calculating with decimals the whole way even though the decimals do not show
in the appropriate columns. Is there a way to eliminate the decimals in the
calculations with the exception of the total. Excel's total and the "old"
calculator's do not match.
Example:
721 divided by 7.46 = 97, 97 minus 156 = (59), (59) multiplied by .3640 =
(21.47) on the calculator and (21.62) on excel.
Can someone help me,
Thanks, Patti
 
G

Guest

Use the ROUND() function

=ROUND(721/7.46,0) will give you 97
=ROUND(-59*.364,2) will give you 21.48

You're not going to get 21.47 unless you truncate

=TRUNC(-59*.364,2) will give you 21.47
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I set Excel to work in 2 decimals only, not use the hidde. 4
How do I align decimals in Excel when not all numbers have % sym. 2
How do I get a combo box to calculate percentages in Excel? 4
How do i calculate the total revenue in Excel? 1
how do i calculate hours worked in excel? 9
How do I sum rounded values from two seperate formulas in Excel? 1
How do I calculate a MTD total - yesterdays sales in Excel? 0
How do I filter using multiple columns in Excel? 1

Top