if true then change the value of a different cell

**ruzbayhhi** · 02-12-2009, 04:15 PM

Dear All,

This has been driving me crazy. I am trying to put an if command on cell C6, which will check to see whether cell A1's value is greater than six. if so, it should add to its value 100, otherwise it should deduct 23.

I really appreciate your help guys!

Jon Deavuila

**NBVC** · 02-12-2009, 04:18 PM

Not quite sure I understand....

you mean?

=if(A1>6,A1+100,A1-23)

**ruzbayhhi** · 02-12-2009, 04:20 PM

NBVC,

Thanks for the quick reply.

In your example, cell c3 will change and I wanted the original cell to change. It is possible, right?

Thanks again

**NBVC** · 02-12-2009, 04:24 PM

For the original cell to change, you need to use VBA code (in the form of a change event macro)... but I am not sure why then you are using C6 to check A1 and then change A1...?

**ruzbayhhi** · 02-12-2009, 04:26 PM

MMM... so I guess there isn't any way of doing it directly through the excel. I am not very acquainted with VBA.

Nevertheless, many thanks for your help!

**NBVC** · 02-12-2009, 04:29 PM

I am just not understanding why you say you want to put a command in C6 to check cell A1 and then change A1? Doesn't seem to make sense to me....

Can you describe with example what you really want to do?