If between Function

[Bravo 1950]

This is the formula that i am using. =IF(M1<=25,"32",IF(M1<>26:50,"60",IF(M1>=51,"85")))

IF THE NUMBER IN COLLUM M1 IS 25 OR LESS RETURN 32 IN DESIGINATED CELL.
IF THE NUMBER IN COLLUM M1 IS BETWEEN 26 & 50 RETURN 60 IN DESIGINATED CELL
IF THE NUMBER IN COLLUM M1 IS 51 OR MORE RETURN 85 IN DESIGINATED CELL

I AM NOT ABLE TO GET ALL THREE FUNCTIONS TO WORK.

HELP IF YOU CAN.

[ConneXionLost]

Try:

Please Login or Register  to view this content.