If "undetermined" or equal andless than 50 - return 1

Attached is supplier performance matrix

Column J contains a number of carriage paid levels. I want to award all the cells that contain undetermined or a value of 50 or below with a point (number 1) in the cell next to e.g column K.

Would anyone now the formula for this?
THS-Supplier-Partnership-Criteria.xlsx
robmarr700Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
You can use:
=IF(OR(J4="undetermined",J4<=50),1,"")
0
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
=IF(OR(TRIM(J3)="undetermined",J3<=50),1,"")

Open in new window

0
 
robmarr700Author Commented:
Both great solutions, thanks!

Rob
0
All Courses

From novice to tech pro — start learning today.