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