Excel 2016 error using Round


  1. Posts : 46
    Microsoft Windows 10 Pro 64-bit Multiprocessor
       #1

    Excel 2016 error using Round


    The following formula gives the correct result for each of the conditions: -

    =IF(GrosInc-PAIncLmt<0,EPA,IF(GrosInc-PAIncLmt-(EPA*2)>=0,0,EPA-(GrosInc-PAIncLmt)/2))

    but if I introduce the Round function: -

    =IF(GrosInc-PAIncLmt<0,EPA,IF(GrosInc-PAIncLmt-(EPA*2)>=0,0,Round(EPA-(GrosInc-PAIncLmt)/2),0))

    in order for the result to be an integer, I get an error message "You've entered too few arguments for this function." Please can someone point out what I have done incorrectly.


      My Computer


  2. Posts : 1,363
    Win7 pro x64
       #2

    Round(EPA-(GrosInc-PAIncLmt)/2),0))
    should be this
    Round(EPA-(GrosInc-PAIncLmt)/2,0)))
      My Computer


  3. Posts : 46
    Microsoft Windows 10 Pro 64-bit Multiprocessor
    Thread Starter
       #3

    Many thanks johnhoh that has done the trick!!
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 23:30.
Find Us