# Changing cell values based on other cells values

1. ## 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.

2. ## Re: Changing cell values based on other cells values

I don't think you have explained this fully...

but for openers:

=IF(\$E5>=60,"S", IF(F5<=59,"F",IF(F5>=0,"R",0)))

3. ## Re: Changing cell values based on other cells values

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

4. ## Re: Changing cell values based on other cells values

Ok here is another file, this is more clear :D

The only problem is when the cell is blank is not working!

this is the formula I used but not working with empty cell

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

5. ## Re: Changing cell values based on other cells values

That's not such an issue:

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

6. ## Re: Changing cell values based on other cells values

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

7. ## Re: Changing cell values based on other cells values

??? see sheet

8. ## Re: Changing cell values based on other cells values

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

9. ## Re: Changing cell values based on other cells values

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

10. ## Re: Changing cell values based on other cells values

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

11. ## Re: Changing cell values based on other cells values

I think I misunderstood what you meant when you said:

this is the formula I used but not working with empty cell

I guessed what you meant by the bit in red... as you did not explain what "not working" meant...

as long as you're sorted now.

12. ## Re: Changing cell values based on other cells values

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

There are currently 1 users browsing this thread. (0 members and 1 guests)