If Function

  • Thread starter Thread starter Tom Donino
  • Start date Start date
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.
 
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,""))
 
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.
 
Back
Top