 OfficeFrustration (http://www.officefrustration.com/index.php)
-   New Users (http://www.officefrustration.com/forumdisplay.php?f=7)

 kirstikate May 25th, 2010 07:15 PM

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

 John May 25th, 2010 07:28 PM

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

 Gord Dibben May 25th, 2010 07:29 PM

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

 Brad May 25th, 2010 07:32 PM

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

 kirstikate May 25th, 2010 07:51 PM

New To Formulas - Help please

Kirstikate

=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

 Dave Peterson May 25th, 2010 08:08 PM

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

 Brad May 25th, 2010 09:05 PM

New To Formulas - Help please

you're welcome
--
Wag more, bark less

"kirstikate" wrote:

Kirstikate

=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

 All times are GMT +1. The time now is 08:13 AM.