Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF STATEMENT HELP NEEDED!!!
Michelle,
I replied to your first posting - no need to double-post. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help needed with "if" statement | Excel Worksheet Functions | |||
IF statement w/ more than 7 arguments needed | Excel Worksheet Functions | |||
If Then statement help needed | Excel Worksheet Functions | |||
If statement help needed please | Excel Discussion (Misc queries) | |||
If statement needed | Excel Worksheet Functions |