How to multiple conditions to validate more than 2 conditions to .
It should enable us to check multiple conditions and return one value at
last, For example we have 3 classifications in a ROW Customer,Wholesaler,Retailer.If it is 100% against customer it should return as "customer" in the specific cell. The same way we must be able to validate other 2 also to the same specific cell |
What do you mean by
"If it is 100% against customer" assuming it means all classifications are the same (100%) but what if it is 2 out of 3? =IF(COUNTIF(A3:C3,customer_criteria)=3,customer,CO UNTIF(A3:C3,wholesaler_criteria)=3,wholesaler, etc)) Regards, Peo Sjoblom "Bhuvana Govind" wrote: It should enable us to check multiple conditions and return one value at last, For example we have 3 classifications in a ROW Customer,Wholesaler,Retailer.If it is 100% against customer it should return as "customer" in the specific cell. The same way we must be able to validate other 2 also to the same specific cell |
All times are GMT +1. The time now is 12:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com