Have excel 2013 use a fomula in one cell only if another cell has a value

I have a column B that have 1500 lines.   In column F I want it to use a simple formula but only if the corresponding cell in B has a value.

So if B2 has anything in it. I want F1 to use this formula =A2&B2&C2&D2&E2

I have tried =IF(B2,"=A2&B2&C2&D2&E2",0)

Where am I messing up?

Thanks!

October 21st, 2014 1:44pm

I have a column B that have 1500 lines.   In column F I want it to use a simple formula but only if the corresponding cell in B has a value.

So if B2 has anything in it. I want F1 to use this formula =A2&B2&C2&D2&E2

I have tried =IF(B2,"=A2&B2&C2&D2&E2",0)

Where am I messing up?

Thanks!

Free Windows Admin Tool Kit Click here and download it now
October 21st, 2014 3:14pm

Thanks!   Perfect!

October 21st, 2014 4:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics