I'm a beginner, using Excel/ Office 365 and we have a simple commission worksheet that pulls values from other workbooks.
Column B is name, C is commission, D is shortage, E is adjusted commission (c plus d)
I can't figure out how to get the syntax correct for the following conditions for column E:
If cell B is zero (no name)/ blank, then make value of Column E=0 OR if column c<$175 and d<0, then add c and b, if not, then return value of 175 OR if c10>175 and d10<0, add c10 and d10, otherwise return value of c10
Its a simple report pulling from other workbooks- We pay a minimum commission of 175 minus any shortages, but if the amount reported is greater than 175, they get the greater amount minus any shortages.
Columns b, c & d are pulling the correct values, but I don't know how to formulate to get column E to figure out all the different conditions.
Basically, if no name is in Column b, ignore everything else and report zero, otherwise, look at the conditions of c & d to report a minimum of 175 minus shortage, or the greater reported amount minus shortage.
Thanks for any and all help!
Bookmarks