excel experts required, page-2

I think you probably need to back up a step or 2 and approach it from a different angle. You should be able to use the IF statement to great effect when it comes to calculating values based on cell contents.

AFAIK there is no such function like you describe. I may be wrong, though.