software

I'm trying to create a spread sheet and don't know this program AT ALL! Here
is what I need it to do..So, here are the equations...

If C6gt;D6 then (C6-D6)*5 ---and put answer in cell X6
If C6lt;D6 then (D6-C6)*10 ---and put answer in cell X6
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 quot;yellowquot; 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
Assuming you can put Y for quot;yellowquot; in cell D6, type the following
formula in cell X6:

=IF(D6=quot;Yquot;,20,IF(C6gt;D6,(C6-D6)*5,IF(C6lt;D6,(D6-C6)*10,quot;Equalquot;)))

You do not specify what you want to happen when C6 = D6, so this
formula returns quot;Equalquot;, but you can change this to what you want.

Pete