Forum Discussion
Solved
IF AND statement help
I have current formulas of =IFS(F3>6000,"Jrny",F3>4500,"4th",F3>3000,"3rd",F3>1500,"2nd",F3<1500,"1st") =IFS(F527>4000,"Jrny",F527>3000,"4th",F527>2000,"3rd",F527>1000,"2nd",F527<1000,"1st")...
If you have Microsoft365 or Office 2021:
=LET(x, IFS(D3="HDR", 2000, OR(D3={"CO","G&P"}), 1500, OR(D3={"ST","LT"}), 1000), IFS(F3>4*x, "Jrny", F3>3*x, "4th", F3>2*x, "3rd", F3>x, "2nd", F3<=x, "1st"))
This one is less straightforward since the progression does not follow the same pattern
72 - 72 - 144 - 216 - 288
vs
288 - 144 - 432 - 576 - 576
Try this:
=LOOKUP(G3, {"2nd","1st","3rd","4th","Jrny"}, IF(OR(D3={"LT","ST"}), {72,72,144,216,288}, {288,144,432,576,576}))
Finally got the formulas all fixed to do what I need. Saved the document. Re-opened it, hit refresh data and then it reverted all the formulas to the previous ones I had input. I don't understand why it does that after saving, closing and re-opening
I'm afraid I cannot explain that.