A - b <> C ????? Problems with subtraction of cells...

[Roger]

I have a problem with some calculations in a spreadsheet.

I have some numbers that have functions tied to them to figure out the value
I want to show...

Example....

Cell B30
SUM(ROUND(B28,3)*B29

I now have other cells H20 = B30
H19 = H15

H23 = h20 - h19.

All cells are showing a currency format. But when you do the subtraction
the H23 shows something different (Looks like a rounding issue).... It is
simple I want to calculate what is shown in the cell. What do I need to do
to do this?

Thanks,

Rog

 

[JulieD]

Hi Roger

check out
http://www.mcgimpsey.com/excel/pennyoff.html

Cheers
JulieD

 

[RagDyeR]

Check out this page of J.E. McGimpsey:

http://www.mcgimpsey.com/excel/pennyoff.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a problem with some calculations in a spreadsheet.

I have some numbers that have functions tied to them to figure out the value
I want to show...

Example....

Cell B30
SUM(ROUND(B28,3)*B29

I now have other cells H20 = B30
H19 = H15

H23 = h20 - h19.

All cells are showing a currency format. But when you do the subtraction
the H23 shows something different (Looks like a rounding issue).... It is
simple I want to calculate what is shown in the cell. What do I need to do
to do this?

Thanks,

Rog

 

[Jerry W. Lewis]

If you want a more specific answer, you need to specify what is in
B25:B29 and H15.

Jerry