I have 3 conditions
score divided into 3 parts 50, 75 and 100 %
If score in cell = 27 then -3
If score in cell = 26<36 = -2
If score in cell = 18<27 = -1
My formula

=IF(F4827,"-3",IF(F48=26<36,"-2",IF(F48<=18<27,"-1")))
If score in cell is 27 shows false
Please advise
Cordially
Beena K
Process Analst