Dear Sirs and Professors ,I want you Help in fount Equation to get the Result By Multiple Conditions
I want This Price From Data Sheet
by Four Conditions ,
1- Excursion Name
2- Supplier Name
3- Vechicle Type
4-By Transfer Region
and if Supplier Name =Supplier,we
will get Price From Supplier Column In Data Sheet and after that to
Multiply in pax Number in B Column
in Total Sheet without care by
Vehicle Type
but if i Choose Spring Tours ,
we will get the Result By this Four Conditions
I want This Price From Data Sheet
by Four Conditions ,
1- Excursion Name
2- Supplier Name
3- Vechicle Type
4-By Transfer Region
and if Supplier Name =Supplier,we
will get Price From Supplier Column In Data Sheet and after that to
Multiply in pax Number in B Column
in Total Sheet without care by
Vehicle Type
but if i Choose Spring Tours ,
we will get the Result By this Four Conditions