I am not very good with formulas. I am not sure how to explain this formula, so I will do my best to describe what I am trying to do.
I have a sheet where cell K31 needs to display certain values depending on the values of cells K29 and D29.
The rules works as follows:
1. If the value of cell K29 is less than half of the value of cell D29, then display the value 10 in cell K31.
2. If the value of cell K29 is half of the value of cell D29, then display the value 20 in cell K31.
3. If the value of cell K29 is equal to the value of cell D29, then display the value 50 in cell K31.
4. If the value of cell K29 is 1-3 higher than the value of cell D29, then display the value 15 in cell K31. (example, K29 = 15 & D29 = 12, 13, or 14, then K31 has a value of 15.
5. If the value of cell K29 is 4-6 higher than the value of cell D29, then display the value 5 in cell K31.
6. If the value of cell K29 is 7 or higher than the value of cell D29, then display the value 0 in cell K31.
That's it. Thank you!
I have a sheet where cell K31 needs to display certain values depending on the values of cells K29 and D29.
The rules works as follows:
1. If the value of cell K29 is less than half of the value of cell D29, then display the value 10 in cell K31.
2. If the value of cell K29 is half of the value of cell D29, then display the value 20 in cell K31.
3. If the value of cell K29 is equal to the value of cell D29, then display the value 50 in cell K31.
4. If the value of cell K29 is 1-3 higher than the value of cell D29, then display the value 15 in cell K31. (example, K29 = 15 & D29 = 12, 13, or 14, then K31 has a value of 15.
5. If the value of cell K29 is 4-6 higher than the value of cell D29, then display the value 5 in cell K31.
6. If the value of cell K29 is 7 or higher than the value of cell D29, then display the value 0 in cell K31.
That's it. Thank you!