I'm using excel 2000 and hope you can help with the following
Cell H15 has the formula 160 x 12.07% which equals 19.312.
I then use this answer in the formula for H16 which is H15 (19.312) x 12.02
which equals 232.13024.
What I need is for H15 to be to 0 dec points so it is 19. I've changed it in the cell format number option but the sum behind it is still to 3 dec points. How do I make this to 0 dec points so the formula in H16 is 19 x 12.02 which equals 228.38.
Hope this makes sense
Thanks Lindsey
Cell H15 has the formula 160 x 12.07% which equals 19.312.
I then use this answer in the formula for H16 which is H15 (19.312) x 12.02
which equals 232.13024.
What I need is for H15 to be to 0 dec points so it is 19. I've changed it in the cell format number option but the sum behind it is still to 3 dec points. How do I make this to 0 dec points so the formula in H16 is 19 x 12.02 which equals 228.38.
Hope this makes sense
Thanks Lindsey