Excel 2016 error using Round

  Nosmas 17:24 05 Jun 2017

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.

What is Markdown?

Markdown lets you add more formatting to your post. Simply type in your post and it will display as written.

If you wish to add bold or italic characters, add a hyperlink to another website, a heading or a horizontal line, simply use the relevent icons above the text input field.

A preview of your post will appear in the grey box below. If you make a change and you're not happy, simply press the back arrow icon to undo.

Post a Reply

4500

Elsewhere on IDG sites

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)