If cell contains W, do this, but if contains L, do this

**alightbreeze** · 01-15-2013, 05:50 AM

I am trying to write a function, that
- if (G3 = W, then (H2+F3)
- if (G3 = L, then (H2-D3)
- If (G3 = P, then = 0 or do nothing)

I can get the function to work for just W or just L etc, but not all 3 together.
Currently I have:
=IF(ISNUMBER(SEARCH("W",G3)),H2+F3) which works for W and
=IF(ISNUMBER(SEARCH("L",G3)),H2-D3) which works for L and
=IF(ISNUMBER(SEARCH("P",G3)),"") which works for P but I was wondering how to put them all into 1 function.

Thanks

**jraj1106** · 01-15-2013, 05:56 AM

Hi.

Try this function:

Please Login or Register  to view this content.

**benishiryo** · 01-15-2013, 05:57 AM

hi alightbreeze, welcome to the forum. try:

Please Login or Register  to view this content.

**alightbreeze** · 01-15-2013, 06:06 AM

Thanks guys,

jraj, I didn't have any luck with that function but benishiryo, yours worked and solved my issue.

Thanks again

If cell contains W, do this, but if contains L, do this

LinkBack

Thread Tools

Rate This Thread

Display

If cell contains W, do this, but if contains L, do this

Re: If cell contains W, do this, but if contains L, do this

Re: If cell contains W, do this, but if contains L, do this

Re: If cell contains W, do this, but if contains L, do this

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions