Formula Help Needed

[bamaisgreat]

I have the formula below I was needing a little help with.
I have another cell C2 that I would like for it to look at also. If there is something in it then have formula look at it before F3.
The formula below is copied down about 30 rows. C2 is by itself.



=IF(ISBLANK(E3),"",F3&" Rev "&E3)

 

[sooshil]

Hi,

Can you please elaborate it more?
What exactly is your query?

 

[jtakw]

Hi,

Do you mean this:

=IF(E3="","",IF(C2<>"",C2,F3)&" Rev "&E3)

 

[bamaisgreat]

Thats almost it. I do however need it to also show f3 after c3.

Here is a breakdown:
IF there is something in C3 then have it shown 1st
then show F3 then E3

 

[jtakw]

Then use this:

=IF(E3="","",IF(C2<>"",C2&" ","")&F3&" Rev "&E3)

 

[bamaisgreat]

That works great. I need to copy this down about 30 cells. All need to increment except C2 it is a single entry.

 

[jtakw]

Oops, forgot about that, just need absolute row reference for C2, revised below:

=IF(E3="","",IF(C$2<>"",C$2&" ","")&F3&" Rev "&E3)

 

[bamaisgreat]

Thanks all for the help.

 

[jtakw]

You're welcome.