Display a value or text in a cell depending on value in another cell

**zoboran** · 05-10-2013, 08:33 AM

Hello to all. I was wondering if anybody can help me. Here is the issue.
I'm trying to create a function in Excel 2010 that would do the following:
If cell B2 has no value the result displayed in C2 would be "/"
If cell B2 has a value 9-72-21-01-R-001 the result in C2 would be ESM 72-21-01 R001
If cell B2 has a value 9-72-21-01-R-145 the result in C2 would be ESM 72-21-01 R145

Value in B2 is selected from drop-down many.

Doc1.jpg

Thanks!

**Pepe Le Mokko** · 05-10-2013, 08:43 AM

=IF(B2="","/", If(B2="9-72-21-01-R-001"," ESM 72-21-01 R001",if(B2="9-72-21-01-R-145","ESM 72-21-01 R145","")))

(perhaps replace commas with semi-colons per regional settings

**benishiryo** · 05-10-2013, 08:44 AM

hi zoboran, welcome to the forum. try:
=IF(B2="","/",IF(B2="9-72-21-01-R-001","ESM 72-21-01 R001","ESM 72-21-01 R145"))

that is assuming you only have 3 types of values.

**Fotis1991** · 05-10-2013, 08:44 AM

Perhaps..

=if(b2="9-72-21-01-R-001";" ESM 72-21-01 R001";if(b2="9-72-21-01-R-145";"ESM 72-21-01 R145";"/"))

**zoboran** · 05-10-2013, 09:50 AM

hmmm, things are a bit more complicated.
C2 cell is just an example.
All the cells of column C should have a value dependent on corresponding B cell.
And there are more than three value options. Would like to avoid typing the formula in the formula bar (too much time

). Is there a predefined function so that I can just copy-paste it?