OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   New Users (http://www.officefrustration.com/forumdisplay.php?f=7)
-   -   New To Formulas - Help please (http://www.officefrustration.com/showthread.php?t=1117160)

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
 
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


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:

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



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

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com