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

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

"upstate" wrote:

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