|
IF AND Formula
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 |
IF AND Formula
Hi,
you were close =IF(AND(C1="Lourdes",D1=50),D1*0.10,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 |
IF AND Formula
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 |
IF AND Formula
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 |
IF AND Formula
You have an extra bracket at the end...
-- HTH... Jim Thomlinson "Eduardo" wrote: Hi, you were close =IF(AND(C1="Lourdes",D1=50),D1*0.10,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 |
IF AND Formula
Good to see you are giving 110% but the op only wanted 10%. Change 1.1 to 0.1
-- HTH... Jim Thomlinson "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 |
IF AND Formula
Many thanks!
-- Kind regards Ann Shaw "Eduardo" wrote: Hi, you were close =IF(AND(C1="Lourdes",D1=50),D1*0.10,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 |
IF AND Formula
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 |
IF AND Formula
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 |
IF AND Formula
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 |
| All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com