Nested IF Formulas and Multiple Criteria

Hey all,

Seems basic, but my use is unique enough I'm not finding help online readily.

I'm trying to have excel check a cell for one of two names and return a different formulated value based on which name and if the cell is empty to just return a '-' as it does now.

I have it working with one name, but adding the second I keep getting 'too many arguments' error.

This is my current formula:


This is how I tried to modify and am getting the error.

=IF(J2="SLIT", G2*F2*.4, IF(J2<>"",IF(J2)="Steve",IF(G2<75,5\*F2,IF(G2>75,10*F2))))

If J2 contains 'Steve' I want to have it check the value in G2 and return a number based on greater or less than 75. If J2 contains 'SLIT' I want it to multiple G2 by F2 to get total dollar sales and return 40% this is due to different venues and commission structures.

Thanks for the help!


/u/Saxplaya91 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


If you throw in an ALT+ENTER before each IF you get the IF statements each on their own row. That makes it easier to count parentheses, etc.


This is wrong: IF(J2) But it would be better to split the logic into separate cells, rather than jamming it all into a single, complex formula,


I see an error at this point: IF(J2)="Steve" -the extra closing parenthesis. And then, on that same IF, there is no FALSE action. Actually, most of your IF statements only have a TRUE path.


I would rewrite with this: `=IF(J2="SLIT",G2*F2*0.4,IF(J2="Steve",IF(G2<75,5*F2,10*F2),""))` Only valid options for J2 is "SPLIT" or "Steve", anything else returns "".


Thank you! Just needed help cleaning up the formatting it seems as the main formulas and context were all there and correct. Solution Verified


You have awarded 1 point to *JetCarson* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


If you have a new enough version you can use IFS, which is much more readable so you'll be able to catch errors easier. AND and OR are good functions to know about too.


Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[AND](/r/Excel/comments/13rs2fn/stub/jlm0eao "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)| |[IF](/r/Excel/comments/13rs2fn/stub/jlm6zuc "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[IFS](/r/Excel/comments/13rs2fn/stub/jlm0eao "Last usage")|[*2019*+: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.](https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45)| |[OR](/r/Excel/comments/13rs2fn/stub/jlm0eao "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13rnqyv)^( has 17 acronyms.) ^([Thread #24179 for this sub, first seen 25th May 2023, 20:29]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)