If Function

  • Thread starter Thread starter Tom Donino
  • Start date Start date
T

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?
 
Tom Donino said:
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?
Click to expand...

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,""))
 
Thank you. It worked, but I substituted O for the = in
(B4="O" and you need the 2nd parentheses at the end.
 
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.
 
Back
Top