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

"Annie" wrote:

Many thanks!
--
Kind regards

Ann Shaw


"Jim Thomlinson" wrote:

Your brackes are out of place...

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

Jim Thomlinson


"Annie" wrote:

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





--
Kind regards

Ann Shaw