Problem with my formula,working for first part but not for the last part.

Karl86

Hi, My formula works for the first 10,9 and 8 but for the others i get invalid operation. the formula is below . Time criticality is a requested go live date/ current date

=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))))))))))

is there an error from 120,7 down to 300,1?

Paul Newcome

Try removing the = from between the 8 and the IF. Same with the = between the 5 and the IF.