View Single Post
Old May 25th, 2010, 07:29 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
Posts: 20,252
Default New To Formulas - Help please


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 11:15:03 -0700, kirstikate

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