If Function
 

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.

If Function
 

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.

If Function
 

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.
-----Original Message-----
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,""))

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


.

If Function
 

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

LeoH

skrev i en meddelelse
...
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.
-----Original Message-----
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,""))

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


.