Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |