"via sarpi" wrote:
is there a nice elegant way to avoid repeating the same
test condition when nesting multiple IF?

See responses to the same question in microsoft.public.excel.misc. Please
do not multi-post in the future. It causes confusion and forces people to
duplicate their responses.