Function has too many arguments...
Solved/Closed
j1969c
venkat1926
- Posts
- 20
- Registration date
- Friday August 28, 2015
- Status
- Member
- Last seen
- April 5, 2016
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- In excel, how many arguments can a function hold?
- Maximum arguments in if function - Guide
- Functionality of wifi - Guide
- Which function can be used to directly bring automated data from one worksheet to another worksheet - Guide
- Functions of spreadsheet - Articles
- Function key stuck on - Guide
1 reply
venkat1926
Sep 10, 2015 at 04:14 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Sep 10, 2015 at 04:14 AM
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.