If and or function problem

[martyloo]

So far my formula does the following:

If cell "E19" = 11 and "F19" = 11

Display what is in cell A42 in sheet Working Strategy

Otherwise

Do the sum cell "D22" - "B19" in sheet Working Strategy

Here is the following formula:-

=IF(AND(E19=11,F19=11),'Working Strategy'!A42,SUM(D22-'Working Strategy'!B19))

I want to add into this formula into the above formula:-

If cell "E19" = 11 and "F19" = 11 and "G19" = 11

Display whats in cell A43 in sheet Working Strategy




Any Ideas How???


using Excel 2010

 

[AlisaA]

If I understand you correctly, it should be:

=IF(AND(E19=11,F19=11,G19<>11),'Working strategy'!A42,IF(AND(E19=11,F19=11,G19=11),'Working strategy'!A43,SUM(D22-'Working strategy'!B19)))

Does this help?