New To Formulas - Help please

[kirstikate]

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

 

[John]

Hi
Try this : =IF(AND(H49+G49=F49,F49=I49),"True","False")
HTH
John

 

[Gord Dibben]

=IF(AND(H49+G49=F49,F49=I49),"True","False")


Gord Dibben MS Excel MVP

 

[Brad]

=if(and(H49+G49=F49,F49=I49),"true","false")

 

[kirstikate]

Thank you Brad.
Kirstikate

=if(and(H49+G49=F49,F49=I49),"true","false")

 

[Dave Peterson]

One more if you want boolean true/false (not text).

=AND(H49+G49=F49,F49=I49)

 

[Brad]

you're welcome
--
Wag more, bark less

Thank you Brad.
Kirstikate