| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
