New
#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.