Tom

From your wording, I take it, that lower case
o or n are not allowed. If this holds, here's one
way to do it:

In J4:

=IF(EXACT(B4,"O"),newteamcost,IF(EXACT(B4,"N"),old teamcost,""))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Tom Donino" skrev i en meddelelse
...
I am having trouble using the if function. I am trying to
have a cell(J4) return either the value of defined name
(newteamcost) or (old teamcost) depending on whether the
value in (b4) is O or N (Capital O or Capital N). Any
help would be appreciated.