Function has too many arguments... [Solved/Closed]
j1969c
Contributor Last seen
July 30, 2015
- Sep 10, 2015 at 04:14 AM
- Posts
- 20
- Registration date
- Friday August 28, 2015
- Last seen
- April 5, 2016
- Posts
- 1865
- Registration date
- Sunday June 14, 2009
- Status
- Excel too many arguments
- Too many arguments excel - Best answers
- Nesting More Than 7 IF Statements in an Excel Function - How-To - Excel
- Search and Find Using VBA - How-To - Excel
- Formula or Argument in excel - Forum - Excel
- Excel to pdf converter free download - Download - PDF
- Spell number in excel 2007 indian rupees download ✓ - Forum - Office Software
1 reply
- Posts
- 1865
- Registration date
- Sunday June 14, 2009
- Status
try in T9
=IF(U9="paid","Paid",IF(TODAY()>B9+15,"Pay now","hold"))
in your formula for an if condition there are only two alternatives one if if condition is correct (pay now) or if the if condition is wrong then the third argument (hold). there cannot be any other choice. that is why error.
=IF(U9="paid","Paid",IF(TODAY()>B9+15,"Pay now","hold"))
in your formula for an if condition there are only two alternatives one if if condition is correct (pay now) or if the if condition is wrong then the third argument (hold). there cannot be any other choice. that is why error.