What formula should I use?

[jessielim96]

Hi,

Can advise which formula should I use if I want to seek the answer as below criteria?

If I need to purchase pen/paper:
1. Company A will be always the priority,
2. Company B will be the 2nd choice if Company A did not sell this item,
3. Company C will be the last choice if both Company A & B does not have the price.

I tried to use "If" function, but it seem incorrect.
Hope to hear from you all soon.

Thanks!!

 

[JazzSP8]

Does this work for you?

=IF(B2<>"",B2,IF(C2<>"",C2,IF(D2<>"",D2,"")))

 

[Aladin Akyurek]

Are you not saying that you want the cheapest company?

 

[jessielim96]

Does this work for you?

=IF(B2<>"",B2,IF(C2<>"",C2,IF(D2<>"",D2,"")))

Omg---- It does!!!
Thank you very much!!!

This sign "<>"" " does it means more & less than no value?

 

[jessielim96]

Are you not saying that you want the cheapest company?

No, I'm not.
Prioritize Company A first.

Anyway, i already got my answer! Thanks!

 

[JazzSP8]

This sign "<>"" " does it means more & less than no value?

It means "not equal to", you can look at it like this; If(B2<>"" - If B2 is not equal to empty

And no problem, glad I could help