IF function

[billykiller05]

I am needing to know if there is a way to setup an if funciton to only look at part of a column. My list will as follows and I need my if function to look at only the last two digits and retun a value for me. I need the if funciton to look and see if the data ends in 00 or not.

60-00
60-01
60-05
60-06
70-00
70-01
70-02 etc

[VBA Noob]

Try

=IF(RIGHT(A1,2)="00",TRUE,FALSE)

VBA Noob

[billykiller05]

That works awesome. You guys are great.

[billykiller05]

Is there a way to have the funciton return part of the column it is checking. If the function you have me is false I would like for the false action to be to give me the first two digits of the data. If it was 60-00 I would like for the false to give me only to 60 or what ever the first two digits are.

[NBVC]

For boolean result you don't really need an IF() statement...

just simply:

Please Login or Register  to view this content.

will give same results.

[VBA Noob]

Maybe

=IF(RIGHT(A1,2)="00",TRUE,LEFT(A1,2))

VBA Noob

[billykiller05]

Once again that was exactly what I was needing. Thanks again.

[VBA Noob]

No problem

Glad it helped

VBA Noob