Formula for multiple Criteria

BonW

Hello,

I need a formula to put a word “READY” to ColumnA Row if ColumnB value contains a word “Invoice” OR if ColumnC value start with number 1 or 2 or 3.

 

ColumnA        ColumnB              ColumnC

  READY           Invoice 1                             

  READY                                          13437

  READY           invoice 24                          

  READY                                           2399

 Thank you for you help.

DKazatsky2

Hi @BonW,

Try this.

=IF(OR(CONTAINS("Invoice", ColumnB@row), LEFT(ColumnC@row, 1) = 1, LEFT(ColumnC@row, 1) = 2, LEFT(ColumnC@row, 1) = 3), "Ready")

Hope that helps,

Dave

DKazatsky2

Hi @BonW,

Try this.

=IF(OR(CONTAINS("Invoice", ColumnB@row), LEFT(ColumnC@row, 1) = 1, LEFT(ColumnC@row, 1) = 2, LEFT(ColumnC@row, 1) = 3), "Ready")

Hope that helps,

Dave

BonW

IT WORK! Thank you very much Dave for your help. I'm still learning.😀