I am trying to enter the following formula in Excel, and I am being told that I have entered too many arguments. I thought however the max was 7, which I do not have. Formula entered:
Purpose is simply to state that if Cell M8 is over 40 but under or equal to 50, then I want to subtract 40 from it, and multiply it by cell O8. If M8 is less than or equal to 40, just enter 0, if M8 is greater than 50, I simply need it to multipy 10 by cell O8.
Solved by T. C. in 13 mins