04-10-2010, 05:00 AM
You need to use nested IF statements:
=if(C12="* Close",7,if(C12="* Short",7,0))
EDIT: Left off a closing parenthesis.
EDIT: My formula assumes it is located in cell Q12. If it is not, the statement becomes:
=if(C12="* Close",Q12="7",if(C12="* Short",Q12=7,0))
=if(C12="* Close",7,if(C12="* Short",7,0))
EDIT: Left off a closing parenthesis.
EDIT: My formula assumes it is located in cell Q12. If it is not, the statement becomes:
=if(C12="* Close",Q12="7",if(C12="* Short",Q12=7,0))