If Function

T

Tom Donino

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.
 
L

Leo Heuser

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"),oldteamcost,""))
 
G

Guest

Thanks for the reply but that is not working. I also
tried removing the (EXACT portion of eac and the end
parentheses but that is not working either.
 
L

Leo Heuser

What is not working?
Please specify.
What happens, when you enter the formula?

LeoH
 
Top