Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to Change the Value in One Cell Based on Value in Another Cell

dkexprogdkexprog Member Posts: 1
Can anyone help me with the code in Excel to change the value in one cell based on the value in another cell? For example, if the value in F4 > 49, I would like the value in G4 to be $100. If the value in F4 < 49, I would like the value in G4 to be $200. I tried the conditional format formula (for cell G4) =IF(F4 > 49,100,200)but it didn't work.

Comments

  • DaiMitnickDaiMitnick Member Posts: 77
    Hi, you had the right idea with =IF(F4 > 49,100,200) only you enter that directly into the cell, not use conditional formatting, that feature is for changing the cell's format, bold, underline, borders, colours etc. Dai


    ------------------------------------------
    Do or do not, there is no try. |
    ------------------------------------------
Sign In or Register to comment.