So far, the help I've gotten on this board has been huge, so many thanks to everyone! Got another puzzler.
In field A, I enter a number
In field B, we enter another number.
Now, in the final field, I need a result to be returned that calculates based on the following rules:
If B is 10% or less of A, display C.
If B is >10% of A, but less than 50%, return H.
If B is >50% of A, but less than 90%, return M
If B is >90% but less than 100% of A, return L.
If B is >A, return F.
So, example:
B = 80.
A = 50.
Final field should be M (greather than 50% of 80, but less than 90% of it).
Any thoughts?
Thanks!
M.
Bookmarks