Changing cell values based on other cells values

Hello everyone,

I am attaching an excel file, I'm trying to figure out how to change the values of other cells based on the input of the previous ones.

In the example attached, I managed to conditionally format and change the cell values in E5 based on the input of the previous cell if it is >= 60 it will change to green and the letter will change to C (Completed) If it is <=59 it will turn to Red and the letter will change to "F"

What I need is to change the letters in cells G5 and I5 to "S" if the value in E5 is "C" and so on for the whole row, here I just included 3 stages but the stages could be more in the row.

Thank you.

Yes I guess I didn't explained it well,

I will get back with a more detailed explanation and another clearer excel example.


Thanks a lot for helping

Thanks Glenn, but still not working when the A1 is Empty, the B1 is not displaying an "S"
Unless there is something that I have missed here

I'm sorry, but when A1 is empty with no value, the B1 is empty as well and not showing anything at all! I just tried the sheet. thanks

Ok I found out the issue here

=IF(A1="","S",IF(A1>=60, "C", IF(A1<=59, "F", IF(A1="", "S"))))

The S is missing in the 1st statement

Now this works: =IF(A1="","S",IF(A1>=60, "C", IF(A1<=59, "F")))

No problem, you already helped me sort it out, thanks a lot