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
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