IF AND Formula

[Annie]

Hi I was looking for some examples of IF AND formulae. I have a holiday
spreadsheet which looks like the info below I want to be able to say that if
C1=Lourdes and D1=50 then d1*10% or else 0 I tried
=IF(AND(C1="Lourdes",D1=50,D1*10%,0)) but its not working. Any ideas why??

A B C D E
101 9pm Lourdes 50 =if(And(C1="Lourdes",D1=50,D1*10%,0))
102 9pm Knock 40
103 9pm Lourdes 50

 

[Eduardo]

Hi,
you were close

=IF(AND(C1="Lourdes",D1=50),D1*0.10,0))

 

[Jim Thomlinson]

Good to see you are giving 110% but the op only wanted 10%. Change 1.1 to 0.1

 

[Annie]

Many thanks!
--
Kind regards

Ann Shaw

Hi,
you were close

=IF(AND(C1="Lourdes",D1=50),D1*0.10,0))

 

[Annie]

Many thanks!
--
Kind regards

Ann Shaw

Your brackes are out of place...

=IF(AND(C1="Lourdes",D1=50),D1*10%,0)

 

[Annie]

Many thanks!
--
Kind regards

Ann Shaw

Just got your bracket in the wrong place.
=IF(AND(C1="Lourdes",D1=50),D1*1.1,0)

 

[Jay Dee]

Dear Annie

You may also use the following formula in cell E1 & copy to rest of the cells:

=($C1="Lourdes")*(($D1)=50)*($D1*0.1)

It worked...

Regards