If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




New To Formulas  Help please
This is probably very easy, but im having trouble  I want to find a formula
that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49 
Ads 
#2




New To Formulas  Help please
Hi
Try this : =IF(AND(H49+G49=F49,F49=I49),"True","False") HTH John "kirstikate" wrote in message ... This is probably very easy, but im having trouble  I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49 
#3




New To Formulas  Help please
=IF(AND(H49+G49=F49,F49=I49),"True","False")
Gord Dibben MS Excel MVP On Tue, 25 May 2010 11:15:03 0700, kirstikate wrote: This is probably very easy, but im having trouble  I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49 
#4




New To Formulas  Help please
=if(and(H49+G49=F49,F49=I49),"true","false")
 Wag more, bark less "kirstikate" wrote: This is probably very easy, but im having trouble  I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49 
#5




New To Formulas  Help please
Thank you Brad.
Kirstikate "Brad" wrote: =if(and(H49+G49=F49,F49=I49),"true","false")  Wag more, bark less "kirstikate" wrote: This is probably very easy, but im having trouble  I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49 
#6




New To Formulas  Help please
One more if you want boolean true/false (not text).
=AND(H49+G49=F49,F49=I49) kirstikate wrote: This is probably very easy, but im having trouble  I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49  Dave Peterson 
#7




New To Formulas  Help please
you're welcome
 Wag more, bark less "kirstikate" wrote: Thank you Brad. Kirstikate "Brad" wrote: =if(and(H49+G49=F49,F49=I49),"true","false")  Wag more, bark less "kirstikate" wrote: This is probably very easy, but im having trouble  I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49 
Thread Tools  
Display Modes  

