IF STATEMENT HELP NEEDED!!!
 

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 C6D6 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

IF STATEMENT HELP NEEDED!!!
 

Michelle,

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

Pete

IF STATEMENT HELP NEEDED!!!
 

Michelle: The first part would be If(C6D6,(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.

"Excel Dummy" wrote:

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 C6D6 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