| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Designer dummy in Excel - Need (nested?) If statement...
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 C6D6 then (C6-D6)*5 ---and put answer in cell X6 If C6<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 "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Excel IF statement to a different worksheet? | Excel Discussion (Misc queries) | |||
| Can I import my business banking statement online into excel? | New Users to Excel | |||
| how fill adatabasein domino designer with information of excel | Excel Worksheet Functions | |||
| SQL Statement and Excel | Charts and Charting in Excel | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
