# 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
Why is excel telling me that this formula has too many arguments?

=IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID"))

I am stationed on cell T9 which already has the function
=IF(TODAY()>=B9+15,"PAY NOW","HOLD")

But I want T9 to show PAID if U9 shows PAID.
Many thanks, Jose Cruz
Related:

## 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
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.