Trying to write the following function in excel. I have tried many combinations and just cant seem to get it to work
If A1>600, and A2<50, then A3=0
If A1>500, and A2<100, then A3=1
If A1>400, and A2<150, then A3=2
This would all be one long formula with a total of 21 possible combinations which would all change the value of the A3 cell. If anyone can help I would really appreciate it.
Solved by C. H. in 19 mins