Thread: IF(AND Question
View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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