IF statement help please.

  • Thread starter Thread starter iroast
  • Start date Start date
I

iroast

Hi everyone. How do I translate this into an IF statement:

If D10 and E10 are TRUE, then look at D5 and E5. If D5 is less then E5
then print the value of D1 in D11.

Thanks in advance
 
I'm not sure what data is being evaluated in d10 or e10 other than th
word "true". If this is the case this should work for you by enterin
this formula in cell d11:

=if(and(d10="true",e10="true",d5<e5),d1," "
 
iroast

in D11

=IF(AND(D10=TRUE,E10=TRUE),IF(D5<E5,D1,"What ever if
false"),"What ever if false")

Note that D10 and E10 have to be boolean (TRUE or FALSE)
of this is not the case, change TRUE with 1 or what ever
the value that represents TRUE, if the value is text
use "Value", you did not specify what to output if either
conditions where false.

Regards
Juan
 
=IF(AND(D10=TRUE,E10=TRUE),IF(D5<E5,D1,"What ever if
false"),"What ever if false")

-------------------------------------------------------------------------

The values of D5 (3) and E5 (6) are the sum of D2-D4 and E2-E4
respectively.

If D10 and E10 have the value of "TRUE", then compare D5 and E5. If D
< E5, then give me the value of D1 ("Apples"), else give me the valu
of E1 ("Oranges"). So, in this case, D11 should display "Apples".



Thanks again
 
BTW:

=IF(AND(D10=TRUE,E10=TRUE),IF D5<E5,D1,"False"),"False")

This function always produces FALSE..
 
Back
Top