Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2016 error using Round

05 Jun 2017   #1
Nosmas

Microsoft Windows 10 Pro 64-bit Multiprocessor
 
 
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 System SpecsSystem Spec
.
05 Jun 2017   #2
johnhoh

Win7 pro x64
 
 

Round(EPA-(GrosInc-PAIncLmt)/2),0))
should be this
Round(EPA-(GrosInc-PAIncLmt)/2,0)))
My System SpecsSystem Spec
06 Jun 2017   #3
Nosmas

Microsoft Windows 10 Pro 64-bit Multiprocessor
 
 

Many thanks johnhoh that has done the trick!!
My System SpecsSystem Spec
.

Reply

 Excel 2016 error using Round




Thread Tools




Similar help and support threads
Thread Forum
MS Excel 2016, cannot open xls files located on network
Hi, When i create a hyperlink for a file (.xlsx, which is located on network ) in excel. Excel is pointing me this: http://i.imgur.com/mFotGY9.png after pressing OK http://i.imgur.com/nOijh9N.png and it stays like that... For other documents is working, but I do not know what to do...
Microsoft Office
Excel 2016
Hi I have been trying to find out what Im doing wrong with this. Its not .pgn data im wanting its just copy info with noation I am wanting to create an Excel 2016 searchable database for ECO Chess openings. I have tried Data>Get data > webpage. I have attached a couple of screen shots to try...
Microsoft Office
BSOD - Excel 2016 (MSO365) App Hang/App Error various error codes
Good Day, Been having an issue with Excel for a while. I have tried quite a few things that i would have thought could have fixed it, first tested it with a new machine (exactly the same spec as this machine) still did the same thing, reinstalled office on this machine and the other machine,...
BSOD Help and Support
Excel 2016: Displaying formulas in the formula bar
I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64-bit. Intel Core i7-4770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the...
Microsoft Office
New feature updates for Power Pivot in Excel 2016
Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs
News


Our Sites

Site Links

About Us

Find 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 09:47.
Twitter Facebook Google+