Good day everyone,
I have this simple problem but complicated, that I couldn't think of how to formulate it in excel.
I want to have a cell that can result based on the reference value set before it, e.g.
I have a result cell in A1 = 5, the reference number in B1 = 4.5.
My formula is =IF(B1<5, "5", "0"), it works but when I change the reference cell B1 bigger than 5, it shows 0.
Can anyone help me to formulate a formula that can adjust to any number I put? Because I'm working in a series calculation, so the cell B1 value may change bigger than 5.
I hope you can understand what I am trying to say and I really appreciate for any help!!!
Bookmarks