Forum Discussion
Formula Help IF/AND/XLOOKUP
I have tried an IF formula, and IF/AND formula, and XLOOKUP and nothing is returning the answer I need. I even tried a long way with the XLOOKUP formula. So can someone help me please. I have attache...
I will use IFS to solve this problem.
F8=IFS(E8<=$B$4,$B$1,E8<=$C$4,$C$2,E8<=$D$4,$D$1,E8<=$E$4,$E$1,TRUE,$F$1)
Down fill the other "Amount" cell with the formula above.
IFS can solve typical interval problems such as your problem. IFS will stop at the logic test that first return "true". Therefore, I didn't need to include the lower bond value at row 3.