LinkBack URL
About LinkBacks
Looks to me like a series if IF' tests that then lead to a calc. So really, all you need to do is add ROUND to the actual calc, not to the tests...
round(CalculationBasics!$B$5*CalculationBasics!$B$6%,0),round(SUM(P3:U3)*CalculationBasics!$B$6%,0)
Looks to me like a series if IF' tests that then lead to a calc. So really, all you need to do is add ROUND to the actual calc, not to the tests...
round(CalculationBasics!$B$5*CalculationBasics!$B$6%,0),round(SUM(P3:U3)*CalculationBasics!$B$6%,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks