Hello,

Have you tried using IFS or nested IF’s formula?

https://www.myonlinetraininghub.com/excel-nested-ifs-explained
https://www.myonlinetraininghub.com/excel-ifs-function

Do a try yourself and if you still need help just give a shout and show what formula you are struggling with.

Br,
Anders

i forget to mention the condition of column c

please add it in the above formula if C=10w

Hi,

Here is a proposal but some information is missing to give an answer that works 100% of the time.

1. What does c=10w mean? Will the cell contain only these three characters and no others? Can these three characters be included in a text, for example: 'Blabla 10w blibli'? It will not be the same search.
2. What happens if the value is less than 1 or greater than 17000? An error message, do nothing?

BR,

Lionel

Dear Lionel Baijot

1.     C=10w and 10w is for ten wheeler vehicle in future i need condition for six wheeler vehicle also but for this time just for ten wheeler

2.     Less then and equal to 7000...here is 7000 is weight in kg.

these are three weights slabs 7000 and 7000 to 12000 and 12000 to 17000 for for now max weight is 17000kg

weight will fall in these three catagories 1-7000....7000.1 to 12000 and 12001 to 17000

i hope every this is clear now.

Also make correction in the under mentioned formula without column C condtion i.e 10 wheeler.

=IF(D5>=7000&D5<=12000,"PK 058",IF(D5>=12000,"PK 059",IF(D5<=7000,"PK 057")))

Thanks in advance for your cooperation.

Then my proposal works (# post 5). See cells in green.

BR,

Lionel