Excel 2016 error using Round

  Nosmas 17:24 05 Jun 2017
Locked

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.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei Mate 20 Pro review: In-depth hands-on

Adobe's groundbreaking prototypes of new features and apps for Creative Cloud

iPhone XR release date, price & specs

Test : le Samsung Galaxy A9