robmarr700
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rob