Forum Discussion

RAMESHGOVIND's avatar
RAMESHGOVIND
Copper Contributor
Oct 01, 2021
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 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

12 Replies

Resources