PDA

View Full Version : Multiply



thair younis
04-06-2012, 03:56 AM
Hi
I need formula
The explanation in attachment
thank you

Bob Phillips
04-06-2012, 04:30 AM
Try

=IF(AND(A2="my place",OR(B2={"petrol","Diesel"})),35,IF(AND(A2="his place",B2="petrol"),17,1))*C2

thair younis
04-06-2012, 06:26 AM
Hi Xld
I thank you very very much Sir

but I think my ( his place ) suppose equal (170) not (10)

and if you not mind I wanna know what mean (,17,1) in your create formula

thank you again

Bob Phillips
04-06-2012, 06:53 AM
It is determining the multiplier, 17 if 'his place' and 'petrol', otherwise just 1 (you din't cover the catch-all condition).

Aussiebear
04-06-2012, 06:59 AM
Have a look at the data you presented. You have two options for the "Side of loading", two options for the "type of product", and two options for the "amount"

All XLD has done is use a variant of the IF AND OR functions to cover all of the options as indicated in the data provided. If the side of loading equals "My Place" and the type of Product equals either "Petrol or Diesel" them multiply by 35 the value of C2 else If side of loading equals "His Place" and the type of product equals "Petrol" then multiply by 17 the value of C2

thair younis
04-06-2012, 07:07 AM
HI
aha
I got it now
thank you