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
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
Can't horizontally scroll via mouse wheel in Excel 2016
So from the title itself. I have a G502 Proteus Spectrum and it has the latest drivers. The sides scrolling works on Browsers, Task Manager, Notepad/++, Visual Studio 2012. The side scroll also doesn't work on my laptop (W8.1, Excel 2013). If there's anything that could enable this, it would be a...
Microsoft Office
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 23:00.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App