Formula Help Needed

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
794
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)
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

sooshil

Board Regular
Joined
Feb 21, 2013
Messages
104
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi,

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

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
Hi,

Do you mean this:

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

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
794
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

Well-known Member
Joined
Jun 29, 2014
Messages
5,146

ADVERTISEMENT

Then use this:

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

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
794
That works great. I need to copy this down about 30 cells. All need to increment except C2 it is a single entry.
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146

ADVERTISEMENT

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

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

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,410
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top