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.
HDR
hardman resources limited
excel experts required, page-2
Add to My Watchlist
What is My Watchlist?