Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JA
 
Posts: n/a
Default


"Bill Kuunders" wrote in message
...
Ash

Looks like you need to round each result before you sum them.
Use in b2 =round(A2/12,2)
and in c2 =round(B2*0.175,2)
before you add them together in d2

Regards
Bill K


Thanks to both who replied. The Round solution seems to be working fine now.

Ash


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding up for down based on cell value Allison Excel Worksheet Functions 3 February 8th 05 10:10 PM
Rounding Issues Louis Excel Discussion (Misc queries) 1 February 4th 05 10:23 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 01:07 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 4 January 5th 05 01:07 PM
specific rounding of formulas which may need to include an IF stat Gerry Wilkins Excel Worksheet Functions 2 January 5th 05 04:11 AM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"