Multiple Criteria in IF arguments

[Hensgen]

What is the correct formula for satisfying multiple criteria in "IF" statements ie; two conditions are to be met before returning designated result data?
eg; =IF(C4>T5ANDF7=D9,A12*I24,0)

[FDibbins]

Hi Hensgen and welcome to the forum

you were almost there, try this...

=IF(and(C4>T5,F7=D9),A12*I24,0)

[Fotis1991]

Try

=IF(AND(C4>T5,F7=D9),A12*124,O)

[Hensgen]

worked perfectly.......Much appreciated

Thanks

[Hensgen]

Ok the below formula is working well, however I now need to add an independent formula "SUM(A4,B4)/2*M4" to the same cell to return either or both results, can I do this? =IF(AND(AJ12=TRUE,AH12=Data!$K$3),Data!L3,IF(AND(AJ12=TRUE,AH12=Data!$K$4),Data!L4,IF(AND(AJ12=TRUE,AH12=Data!$K$5),Data!L5,IF(AND(AJ12=TRUE,AH12=Data!$K$6),Data!L6,IF(AND(AJ12=TRUE,AH12=Data!$K$7),Data!L7,IF(AND(AJ12=TRUE,AH12=Data!$K$8),Data!L8,IF(AND(AJ12=TRUE,AH12=Data!$K$9),Data!L9,IF(AND(AJ12=TRUE,AH12=Data!$K$10),Data!L10,IF(AND(AJ12=TRUE,AH12=Data!$K$11),Data!L11,IF(AND(AJ12=TRUE,AH12=Data!$K$12),Data!L12,IF(AND(AJ12=TRUE,AH12=Data!$K$13),Data!L13,IF(AND(AJ12=TRUE,AH12=Data!$K$14),Data!L14,""))))))))))))+IF(AND(AJ12=TRUE,AI12=Data!$K$3),Data!L3,IF(AND(AJ12=TRUE,AI12=Data!$K$4),Data!L4,IF(AND(AJ12=TRUE,AI12=Data!$K$5),Data!L5,IF(AND(AJ12=TRUE,AI12=Data!$K$6),Data!L6,IF(AND(AJ12=TRUE,AI12=Data!$K$7),Data!L7,IF(AND(AJ12=TRUE,AI12=Data!$K$8),Data!L8,IF(AND(AJ12=TRUE,AI12=Data!$K$9),Data!L9,IF(AND(AJ12=TRUE,AI12=Data!$K$10),Data!L10,IF(AND(AJ12=TRUE,AI12=Data!$K$11),Data!L11,IF(AND(AJ12=TRUE,AI12=Data!$K$12),Data!L12,IF(AND(AJ12=TRUE,AI12=Data!$K$13),Data!L13,IF(AND(AJ12=TRUE,AI12=Data!$K$14),Data!L14,""))))))))))))

[FDibbins]

Hensgen, if this is the same question as what you are asking in this thread....

http://www.excelforum.com/excel-form...same-cell.html

Then please do not post duplicate questions

[FDibbins]

duplicate post deleted

[Hensgen]

it is, sorry just learning the whole Forum thing...