Forum Discussion
RAMESHGOVIND
Oct 01, 2021Copper Contributor
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 DISPLAY "M DUES"
IF CELL K2 VALUE IS >75 AND <100 RESULT SHOULD DISPLAY "L DUES"
IF CELL K2 VALUE IS >100 AND <500 RESULT SHOULD DISPLAY "OVER DUE"
PLEASE HELP ME IN THIS
EMAIL ID : shrirameshgovind@gmail.com
Great, thank you for the update
12 Replies
- RAMESHGOVINDCopper Contributor
- RAMESHGOVINDCopper ContributorUSING MS EXCEL 2007
OS WINDOWS 7 ULTIMATE- bosinanderIron Contributor
RAMESHGOVIND I would suggest a table with the limits and VLOOKUP to get the result;
=VLOOKUP(K2;O2:Q7;3)
The table can, if you like, be moved to another sheet with preferences (cut and paste).
- RAMESHGOVINDCopper Contributor