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

- - **New To Formulas - Help please**
(*http://www.officefrustration.com/showthread.php?t=1117160*)

New To Formulas - Help pleaseThis 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 |

New To Formulas - Help pleaseHi
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 |

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 |

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 |

New To Formulas - Help pleaseThank 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 |

New To Formulas - Help pleaseOne 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 |

New To Formulas - Help pleaseyou'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