Trying to determine the commission based off of a particular margin and I'm stuck.
Trying to make a certain percentage show up in L2.
This is what I think it should say, just can't make it into a function properly.
If J2 is between 41 and 100 then L2 = 8
If J2 is between 31 and 40 then L2 = 7
and so on and so forth.
My head feels like a monday. Can anyone help?
Thanks!
Bookmarks