Cell R5 = IF A1 is less than B2 and more than B3 then R5 should equal F1, or if A1 is less than C2 and more than C3, then R5 should equal F2, or if A1 is less than D2 and more than D3, then R5 should equal F3.
Seems simple enough but I dont know how to do it. Can anyone help?Thanks heaps.
Seems simple enough but I dont know how to do it. Can anyone help?Thanks heaps.