Function has too many arguments...
Solved/Closed
j1969c
Posts
20
Registration date
Friday 28 August 2015
Status
Member
Last seen
5 April 2016
-
9 Sep 2015 à 21:11
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 10 Sep 2015 à 04:14
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 10 Sep 2015 à 04:14
Related:
- In excel, how many arguments can a function hold?
- What is the function of a hard drive - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How many if functions can be nested in excel - Guide
- Iserror function in excel with vlookup - Guide
- Arrow keys not working in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
10 Sep 2015 à 04:14
10 Sep 2015 à 04:14
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.
