Using IF Statement
 

I have to columns and basically want to say IF B15= any cell in Column A, put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS

=IF(ISNA(MATCH(B15,A:A,0)),"","X")

--
HTH

Bob Phillips

"ClaytonS" wrote in message
...
I have to columns and basically want to say IF B15= any cell in Column A,
put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS

Try

=IF(B15="*","X","")

In my equation I had a real number to specify and it worked but if you
specify if B15 equals anything then the answer may always be X or Nothing.


"ClaytonS" wrote:

I have to columns and basically want to say IF B15= any cell in Column A, put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS

On Wed, 18 May 2005 10:16:04 -0700, "ClaytonS" wrote:

I have to columns and basically want to say IF B15= any cell in Column A, put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS

=IF(COUNTIF(A:A,B15)0,"X","")


--ron

Thank you so much for all your help!

"Ron Rosenfeld" wrote:

On Wed, 18 May 2005 10:16:04 -0700, "ClaytonS" wrote:

I have to columns and basically want to say IF B15= any cell in Column A, put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS

=IF(COUNTIF(A:A,B15)0,"X","")


--ron

Thanks!

"cisse_5" wrote:

Try

=IF(B15="*","X","")

In my equation I had a real number to specify and it worked but if you
specify if B15 equals anything then the answer may always be X or Nothing.


"ClaytonS" wrote:

I have to columns and basically want to say IF B15= any cell in Column A, put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS

Thanks!

"Bob Phillips" wrote:

=IF(ISNA(MATCH(B15,A:A,0)),"","X")

--
HTH

Bob Phillips

"ClaytonS" wrote in message
...
I have to columns and basically want to say IF B15= any cell in Column A,
put
an "X" in this cell. If it does not equal a number in columan, leave it
blank. I am not sure how to write this statement. I'm trying to verify
Journal entry numbers that are posted when i pull them into a spreadsheet
from Oracle.

Any help would be greatly appreciated.

thanks - ClaytonS