IF Formula

Karl86

Hi I would like help on a formula to score time criticality. Ive tried the below but its coming up with errors. I also would like to add a formula that if there are any negative numbers such as -201 then this would show as "10"

Formula i used below but not working

=IF([Time Criticality]@row <= 30, "10", IF([Time Criticality]@row <= 60, "9", IF([Time Criticality]@row <= 90, "8", =IF([Time Criticality]@row <= 120, "7", IF([Time Criticality]@row <= 150, "6", IF([Time Criticality]@row <= 180, "5", =IF([Time Criticality]@row <= 210, "4", IF([Time Criticality]@row <= 240, "3", IF([Time Criticality]@row <= 270, "2", IF([Time Criticality]@row <= 300, "1",))))))))))

Many thanks

Paul Newcome

What error are you getting? The first thing I see is that comma at the end before the series of closing parenthesis needs removed.

No additional logic should be needed for negative numbers as they should be caught by the first IF that says anything less than or equal to 30 outputs "10". Since negative numbers are less than 30, they should be caught here.