IF(AND Question
 

If possible, can this formula be corrected?
I get the answer "FALSE", and I need a number.
G19 number is 25, H19 number is 28, I19 number is 31, and
J19 number is 35.
IF not, what other formula could I use to get the results?

=IF(AND(A1="B",E10="N"),G19,H19)=IF(AND(A1="C",E10 ="N"),I19,J19)
Thanks In Advance

Your question is waaay too ambiguous. Help us help you. Explain what you
are trying to accomplish.

The formula returns FALSE because you are comparing the results of two
different calculations, i.e., does IF(#1)=IF(#2)

"At A Loss" wrote:

If possible, can this formula be corrected?
I get the answer "FALSE", and I need a number.
G19 number is 25, H19 number is 28, I19 number is 31, and
J19 number is 35.
IF not, what other formula could I use to get the results?

=IF(AND(A1="B",E10="N"),G19,H19)=IF(AND(A1="C",E10 ="N"),I19,J19)
Thanks In Advance

Its difficult to see what you want to achieve from this, the syntax of the
nested IF formula is wrong, it needs to be something like:-
=IF(AND(A1="B",E1="N"),"Something",IF(AND(A1="C",E 10="N"),"Something
Else","What to display it niether argument is TRUE"))
Regards,
Alan.
"At A Loss" wrote in message
...
If possible, can this formula be corrected?
I get the answer "FALSE", and I need a number.
G19 number is 25, H19 number is 28, I19 number is 31, and
J19 number is 35.
IF not, what other formula could I use to get the results?

=IF(AND(A1="B",E10="N"),G19,H19)=IF(AND(A1="C",E10 ="N"),I19,J19)
Thanks In Advance

The FALSE result comes from having to = in the formula. You are tesing the
value before the second = is the same as the value after the second =.

The logic of what you are trying to do, is somewhat ambiguous.
Basically, your True results all have to have E10="N". What happens if
E10<"N"?
Maybe you need something like

=IF(E10<"N","No result",IF(A1="B",G19,IF(A1="C",H19,I19))

but that is not utilising the J19 value. Maybe that is the result you want
for the "No Result".
From what you have posted, I an only "second guess" what you are trying to
do.
Perhaps you can rethink the problem and post back.

--
Regards

Roger Govier


"At A Loss" wrote in message
...
If possible, can this formula be corrected?
I get the answer "FALSE", and I need a number.
G19 number is 25, H19 number is 28, I19 number is 31, and
J19 number is 35.
IF not, what other formula could I use to get the results?

=IF(AND(A1="B",E10="N"),G19,H19)=IF(AND(A1="C",E10 ="N"),I19,J19)
Thanks In Advance