Please Help....multiple IF formula

[SteveK251]

Hi. Really struggling with this! Need a formula that achieves the following:-

If the text in column B states POT then it needs to return the text of column C & D combined. So if Column C Text is DOC123 and column D Text is 801-010 it returns a value of DOC123801-010

However if it states POR in column b (not POT) then it returns the exact same text as in column D. So if POS it would only return a value of 801-010.

is the above possible?
Any help greatly appreciated.

 

[jasonb75]

You can do that with

=IF(B2="POT",C2,"")&D2

Or if you want to leave the text blank if column B is empty then

=IF(B2="","",IF(B2="POT",C2,"")&D2)

 

[SteveK251]

Thanks Jason but can i also get it to do the IF search for POR in same formula and return a different value (exact same text as column D)

 

[Fluff]

How about

=IF(B2="POT",C2&D2,IF(B2="POR",D2,""))

 

[SteveK251]

This is almost working perfectly. Its my fault i forgot to say for POT in column B it can also display POT>. Either POT or POT> need to return C&D value. I assumed it would still work as would just pick up the POT element. Sorry.

 

[Fluff]

How about

=IF(LEFT(B2,3)="POT",C2&D2,IF(B2="POR",D2,""))

 

[jasonb75]

can i also get it to do the IF search for POR in same formula and return a different value

My way of reading the original question was that POT should return the combination of C&D, anything else would only show D.

If that is the case then you don't need to check for POR, the formula assumes this by process of elimination. If it is not empty and it is not POT then it must be POR.

 

[SteveK251]

Thanks for your help Jason. It was struggling with the POT> if it returned this is column B. I have managed to just add this to the previous IF formula you gave me for if just POT and all seems to be doing as hoped now. Thanks so much for this this. I Maybe coming back shortly with some more problems.