Formula error...
Cell B2 has a formula setup in it so it enters the team that is in a
different tab into it. I am trying to setup an if formula in cell A2 that either puts an AL if true or NL if false. For example, Cell B2 says KC (which is from a formula setup to equal a cell in another tab). I type in cell A2 the following: =if(B2="KC","AL","NL") and it gives me NL. If I override the formula in cell B2 and just type in KC it works right and gives me AL. Any idea why it doesn't work when the formula produces KC? Thank you. |
You might have a space in your formula, if this work you definitely have a
space or something else not visible =IF(ISNUMBER(FIND("KC",B2)),"AL","NL") -- Regards, Peo Sjoblom "Jambruins" wrote in message ... Cell B2 has a formula setup in it so it enters the team that is in a different tab into it. I am trying to setup an if formula in cell A2 that either puts an AL if true or NL if false. For example, Cell B2 says KC (which is from a formula setup to equal a cell in another tab). I type in cell A2 the following: =if(B2="KC","AL","NL") and it gives me NL. If I override the formula in cell B2 and just type in KC it works right and gives me AL. Any idea why it doesn't work when the formula produces KC? Thank you. |
that did work. Now I want the same thing but with an or function added to
the formula. Here is what my actual formula is but it doesn't work, it gives me NL even if cell B2 is BOS or TOR or any of them: =IF(OR(B2="BAL",B2="BOS",B2="NYY",B2="TB",B2="TOR" ,B2="CWS",B2="CLE",B2="DET",B2="KC",B2="MIN",B2="L AA",B2="OAK",B2="SEA",B2="TEX"),"AL","NL") How should I enter this formula to have it work? Thanks "Peo Sjoblom" wrote: You might have a space in your formula, if this work you definitely have a space or something else not visible =IF(ISNUMBER(FIND("KC",B2)),"AL","NL") -- Regards, Peo Sjoblom "Jambruins" wrote in message ... Cell B2 has a formula setup in it so it enters the team that is in a different tab into it. I am trying to setup an if formula in cell A2 that either puts an AL if true or NL if false. For example, Cell B2 says KC (which is from a formula setup to equal a cell in another tab). I type in cell A2 the following: =if(B2="KC","AL","NL") and it gives me NL. If I override the formula in cell B2 and just type in KC it works right and gives me AL. Any idea why it doesn't work when the formula produces KC? Thank you. |
All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com