I guess you want the IF and AND functions, then. The AND function takes two
or more conditions and returns TRUE if they're all TRUE, FALSE otherwise.
Like this:

=AND(B2=A4,D2=1)

That returns either TRUE or FALSE. Now, before you combine it with the IF
function you need to fill in a blank you didn't mention before: What do you
want X2 to be equal to if the above is NOT true?

Then (using the 2nd relationship as an example) I don't understand your
specifying the "then cell x3 = 8" part... if that doesn't mean Cell X3, what
does it mean? Just so we are clear about how Excel works, you can't have a
formula in one cell "push" out a value into another cell... cells can only
"pull" values in... so each cell that you want to display a value in has to
have its own formula.

Now I have to go back to my confused state and wonder, as I mentioned
previously, about your use of "then cell x3 = 8" in that original 2nd
formula and now also your mentioning "X3 is the cell that I am putting the
formula in" in your previous post. I am really confused as to what tests are
supposed to go into what cells.

I wish to set a cell to = a value based values in 2 different cells
so I wish the value to be store in cell X2 the two cells I am looking in are
B2 and D3
eg:

IF B2 = 4 and D2 = 1 then cell X2 = 10
OR
IF B2 = 4 and D3 = 4 then cell X2 = 8
OR
IF B2 = 3 and D4 = 4 then cell X2 = 6
OR
IF B2 = 5 and D4 = 1 then cell X2 = 12

Regards - Paul

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.