If statement, push rows down if false

[sjc4]

Hi everyone. First off let me say i'm glad to be back on the site, and thanks for reading. Here is my question:

I want to run an if statement, and if this if statement is false i want the excel spreadsheet to push the row that is false and compare it to the next row down. (IF A1=B1, "true", false then move rows down one cell) Any suggestions for this?

 

[cjcobra]

Just keep going with your IF statements. I can't remember how many, but I've hit a max in number of nested IF statements.

=IF(A1=B1, "true", IF(A1=B2, "true2", IF(A1=B3, "true3", "Nothing")))

 

[sjc4]

thanks for the input. i'll go with that. hey, while i have your attention, i have another question. i have two cells, one is a number and the other is a word. i want to combine the number and the first 5 letters of the word. only the first five. do you know how to do that?

 

[Robert Mika]

A1 number
A2 word

=A1&" "&left(A2,5)