| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check Box Question
How do I achieve the following?
If cell D10 has anything of any value in it I would like cell D5 to display a result of €˜X however if cell D10 is blank then I would like cell D5 to remain blank. The 'X' is actually be an 'X' Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Box Question
Try this entered in D5:
=IF(D10="","","X") -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How do I achieve the following? If cell D10 has anything of any value in it I would like cell D5 to display a result of 'X' however if cell D10 is blank then I would like cell D5 to remain blank. The 'X' is actually be an 'X' Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Box Question
How would I adjust your formula to handle three different cells at the same
time? i.e. D10 and/or G10 and/or J10. That is to say if cell D10 and/or G10 and/or J10 have anything of any value in either of them I would like cell D5 to display a result of 'X' however if cell D10 and/or G10 and/or J10 are all blank then I would like cell D5 to remain blank. Thanks, Ksean "T. Valko" wrote: Try this entered in D5: =IF(D10="","","X") -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How do I achieve the following? If cell D10 has anything of any value in it I would like cell D5 to display a result of 'X' however if cell D10 is blank then I would like cell D5 to remain blank. The 'X' is actually be an 'X' Thanks . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Box Question
Maybe this...
=IF(COUNTA(D10,G10,J10),"X","") If any of those cells contain formulas that might return formula blanks ("") the formula will "see" that and consider that to be something in the cell. -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How would I adjust your formula to handle three different cells at the same time? i.e. D10 and/or G10 and/or J10. That is to say if cell D10 and/or G10 and/or J10 have anything of any value in either of them I would like cell D5 to display a result of 'X' however if cell D10 and/or G10 and/or J10 are all blank then I would like cell D5 to remain blank. Thanks, Ksean "T. Valko" wrote: Try this entered in D5: =IF(D10="","","X") -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How do I achieve the following? If cell D10 has anything of any value in it I would like cell D5 to display a result of 'X' however if cell D10 is blank then I would like cell D5 to remain blank. The 'X' is actually be an 'X' Thanks . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Box Question
Thanks, your formulas worked great!
"T. Valko" wrote: Maybe this... =IF(COUNTA(D10,G10,J10),"X","") If any of those cells contain formulas that might return formula blanks ("") the formula will "see" that and consider that to be something in the cell. -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How would I adjust your formula to handle three different cells at the same time? i.e. D10 and/or G10 and/or J10. That is to say if cell D10 and/or G10 and/or J10 have anything of any value in either of them I would like cell D5 to display a result of 'X' however if cell D10 and/or G10 and/or J10 are all blank then I would like cell D5 to remain blank. Thanks, Ksean "T. Valko" wrote: Try this entered in D5: =IF(D10="","","X") -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How do I achieve the following? If cell D10 has anything of any value in it I would like cell D5 to display a result of 'X' however if cell D10 is blank then I would like cell D5 to remain blank. The 'X' is actually be an 'X' Thanks . . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check Box Question
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Ksean" wrote in message ... Thanks, your formulas worked great! "T. Valko" wrote: Maybe this... =IF(COUNTA(D10,G10,J10),"X","") If any of those cells contain formulas that might return formula blanks ("") the formula will "see" that and consider that to be something in the cell. -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How would I adjust your formula to handle three different cells at the same time? i.e. D10 and/or G10 and/or J10. That is to say if cell D10 and/or G10 and/or J10 have anything of any value in either of them I would like cell D5 to display a result of 'X' however if cell D10 and/or G10 and/or J10 are all blank then I would like cell D5 to remain blank. Thanks, Ksean "T. Valko" wrote: Try this entered in D5: =IF(D10="","","X") -- Biff Microsoft Excel MVP "Ksean" wrote in message ... How do I achieve the following? If cell D10 has anything of any value in it I would like cell D5 to display a result of 'X' however if cell D10 is blank then I would like cell D5 to remain blank. The 'X' is actually be an 'X' Thanks . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check box question | Excel Worksheet Functions | |||
| Question regarding VLookup and if it can check two columns of data | Excel Worksheet Functions | |||
| Check box logic question | Excel Worksheet Functions | |||
| Question to check the conditions and then print the result. | New Users to Excel | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Hybrid Mode
