Regouin
02-28-2005, 07:26 AM
Ok, probably a fairly simple problem, but i cant get it right.
I want a certain cell (a1) to show a certain value from a different sheet (sheet2!a1) but only show this value when any of the cells in the following range (sheet2!h2:h45) are not empty. Most logical is =IF(sheet2!h2:h45="";"";sheet2!a1) but this only works when the majority of the cells in the range show a value, now i want it to also display sheet2!a1 when only 1 cell in the range shows a value. preferrably no VBA and keep the formula as short as possible.
TIA
frank
I want a certain cell (a1) to show a certain value from a different sheet (sheet2!a1) but only show this value when any of the cells in the following range (sheet2!h2:h45) are not empty. Most logical is =IF(sheet2!h2:h45="";"";sheet2!a1) but this only works when the majority of the cells in the range show a value, now i want it to also display sheet2!a1 when only 1 cell in the range shows a value. preferrably no VBA and keep the formula as short as possible.
TIA
frank