If Function

[Tom Donino]

I am trying to use the IF function to return the value
of named cells (oldteamcost) or (newteamcost) depending
on the value in cell (b4) O or N (capital O or Capital N).
How do Get the function to look for the capital O or N
instead of a number?

 

[Frank Kabel]

Hi Tom
=IF(B4="=",oldteamcost,IF(B4="N",newteamcost,"")

HTH
Frank

 

[Paul]

I am trying to use the IF function to return the value
of named cells (oldteamcost) or (newteamcost) depending
on the value in cell (b4) O or N (capital O or Capital N).
How do Get the function to look for the capital O or N
instead of a number?

If O and N are the only possibilities, you only need to test for one of
them. For example:
=IF(B4="O",oldteamcost,newteamcost)

If there are other possibilities, you might use something like:
=IF(B4="O",oldteamcost,IF(B4="N",newteamcost,""))

 

[Tom Donino]

Thank you. It worked, but I substituted O for the = in
(B4="O" and you need the 2nd parentheses at the end.

 

[Tom Donino]

Thanks, that's exactly how I finally got it to work. I
wasn't using the = in front which is why i couldn't get
it to work.