Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula i think?
Nope you understood,
Its worked perfect, thanks for your help, Steve. "John Bundy" wrote: If you are saying one more column (total of 3) with a y,n just select column d and insert column and repeat the process you did with the first two. Then this would be your formula =IF(D11="y",IF(E11="y",IF(F11="y","Complete","Not Complete"),"Not Complete")) if i misunderstand let me know John "k1ngy" wrote: Spot on that worked perfect, one other question though, how do i add to this so i have d11 and e11 then add a column so f11 has a y,n and g11 becomes the complete,not complete, Thanks, "John Bundy" wrote: In the two columns you want y or n highlight the area you want these selections to be in, then go to Data-Validation under allow select list and in the box type Y, N. This makes a dropdown in those cells in which you choose one or the other (you can still type if you rather). If D11 and E11 have you Y and N the F11 formula would be: =IF(D11="y", IF(E11="y","Complete","Not Complete"),"Not Complete") select all cells with this formula Next go to Format-Conditional Format and in the second box choose equals and in the box that appears to the right type Not Complete, then on the third tab select a color such as red. That should do you! John "k1ngy" wrote: Hi, I have a chart and in it at the end i want a cell to say complete or not complete depending on answers in previous cells, for example Processes to do date due checked wi complete complete? returns 15-Dec Y N complete Picking 15-Dec Y Y not complete So word returns is A2 15Dec is B2 so on to complete or non complete in E2 an so on down so all i enter is Y or N in checked and wi complete boxes and words complete or not complete enter themselves. Also if there is something funky with the colour of the box or text even better, Please help ta, Steve. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |