Hi
How do I add ROUND,0 to the following formula please
=IF(VLOOKUP($B3, EmployeeMaster!$A:$L, 12, 0)="Y",IF(SUM(V3:AA3)>SUM(P3:U3),0,IF(SUM(P3:U3)>CalculationBasics!$B$5,CalculationBasics!$B$5*CalculationBasics!$B$6%,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
You can also simplify, to wit:
Please Login or Register to view this content.
Thank you it worked Great !Originally Posted by joeu2004
You can also simplify, to wit:
Please Login or Register to view this content.
Nicely done. I didnt even think to see if it could be simplifiedYou can also simplify, to wit:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks