Formula Help Needed

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
821
Office Version
  1. 365
Platform
  1. Windows
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)
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Hi,

Can you please elaborate it more?
What exactly is your query?
 
Upvote 0
Hi,

Do you mean this:

=IF(E3="","",IF(C2<>"",C2,F3)&" Rev "&E3)
 
Upvote 0
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
 
Upvote 0
Then use this:

=IF(E3="","",IF(C2<>"",C2&" ","")&F3&" Rev "&E3)
 
Upvote 0
That works great. I need to copy this down about 30 cells. All need to increment except C2 it is a single entry.
 
Upvote 0
Oops, forgot about that, just need absolute row reference for C2, revised below:

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

Forum statistics

Threads
1,213,585
Messages
6,114,520
Members
448,575
Latest member
hycrow

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top