Multiple IF formula

[RAJESH SHAH]

Hello experts
I need your expert suggestion to correct this formula.
Thank you in advance.

[Pepe Le Mokko]

After almost 800 posts you should know that a sheet is worth 1000 pictures...
Remove the three parenthesis after the last " cancelled" and add two at the end of the formula

[RAJESH SHAH]

Ok. This is the sample workbook.

[Pepe Le Mokko]

=IF(D2="URP";"B2C";IF(D2="Export";"Export";IF(D2="Cancelled";"Cancelled";"B2B"))) replace semi colons with commas if needed

[jeffreybrown]

I think this might work better...

=IF(D2="URP","B2C",IF(D2="Export","Export",IF(D2="Cancelled","Cancelled","B2B")))

[RAJESH SHAH]

Thankyou Pepe Le Mokko.

[jeffreybrown]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[RAJESH SHAH]

Thanks jeff. I replaced the : with commas and got it right.

[josephteh]

Try, =IFERROR(LOOKUP(D2,{"Cancelled","Export","URP"},{"Cancelled","Export","B2C"}),"B2B")