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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.