Forum Discussion
Solved
help me with creating a formula
I NEED A FORMULA LIKE THIS IF CELL K2 VALUE IS <5 RESULT SHOULD DISPLAY "NO DUES" IF CELL K2 VALUE IS >5 AND <40 RESULT SHOULD DISPLAY "S DUES" IF CELL K2 VALUE IS >40 AND <75 RESULT SHOULD DISPLA...
Great, thank you for the update
As variant
=LOOKUP(K2, {0,5,40,75,100},{"NO DUES","S DUES","M DUES","L DUES","OVER DUE"})and drag it down
THANKS SIR, BUT I NEED THIS RESULT IN ENTIRE WORK BOOK. PLS LOOK FORWARD THE IMG WHICH I UPLOADED. THANKS FOR THE VALUABLE TIME