I need help figuring out the correct formula. I have a monthly report that shows monthly results as well as YE. The current month being reported needs to return a result & that 1 cell needs to up date when the new monthly number is populated. Here's example: Cells G4 thru R4 (January thru December respectfully) is for individual month result. S4 has my formula as follows =ifs(g4>=81%,"5",g4>=80%,"4",g4>=75%,"3",g4>=70%,"2",g4>1%,"1",true,"") So that works if cell G4 is populated but I want the formula in S4 to look at R4 & if thats blank then look at Q4 and populate the appropriate rating as I have currently in S4. And so on, if R4 is blank then look at P4. Bottom line i want it to populate rating based on G4 if populated, Rate for H4 if that is populated. I hope this makes sense.