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!
By - Saxplaya91