Hello,
I am trying to include (3) IF functions in a cell, but I receive an error message saying I have too many arguments.
Here are the three IF functions I am trying to include:
IF(C17="Apple",(C19-1)*B49
IF(C17=3,"Orange",0)
IF(C18=3,"Pear",5)
How can I combine these? I believe Excel allows up to 7 IF arguments?
Thank you!
Bookmarks