Your conditions are a bit ambigous, shouldn't the first criteria be =37 ?

Conditions for the formula below:

F48 =37 result -3
F48 between 26 and 36 result -2
F48 between 18 and 25 result -1
F48 < 18 result 0

=IF(F48=37,-3,IF(F48=26,-2,IF(F48=18,-1,0)))

Hopes this helps.
....
Per

"Beena K" <Beena skrev i meddelelsen
...
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