Many thanks!
--
Kind regards

Ann Shaw


"RonaldoOneNil" wrote:

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

"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