IF STATEMENT HELP NEEDED!!!

[Guest]

I'm trying to create a spread sheet and don't know this program AT ALL! I'm a
designer and math and art just don't mix...

So, here are the equations...
In cell X6 I enter:
If C6>D6 then (C6-D6)*5
or
If C6<D6 then (D6-C6)*10
But,
if cell D6 is yellow --- Put 20 in cell X6

So, I need some sort of identifier in the equation saying whether the cell
is yellow or not. I'm sure excel doesn't recognize "yellow" but there must be
another way. I can put a letter with a number in that cell if necessary.

I'm not sure this is making sence, but if anyone out there can help, I'd
truely appreciate it. Thanks! Michelle

 

[Pete]

Michelle,

I replied to your first posting - no need to double-post.

Pete

 

[Guest]

Michelle: The first part would be If(C6>D6,(C6-D6)*5,(D6-C6)*10). Now, I
assume you are using conditional formatting to change the cell to yellow.
So, using that same condition (let's say D=12 then yellow), put an If
statement in X6 reflecting that... in X6 type If(D6=12,20," ")

Hope this helps.