Function has too many arguments...
Solved/Closed
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
Sep 9, 2015 at 09:11 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 10, 2015 at 04:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 10, 2015 at 04:14 AM
Related:
- In excel, how many arguments can a function hold?
- How to take screenshot in excel - Guide
- Number to words in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- How to change author in excel - Guide
- Excel free download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 10, 2015 at 04:14 AM
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.
