excel 2007 formulas help

**docrobo** · 10-09-2011, 03:32 PM

=IF(AB12="LOSE",W12*2,IF(AB12="WIN",0.1,Q12))

I have been able to formulate the above formula so far but have not been able to complete it to how I need it to work. I want to be able to also add the use of the word "POSTPONED". If the word POSTPONED is entered in to cell AB12 the amount carried forward in to the the formula cell should stay the same as W12.

**daddylonglegs** · 10-09-2011, 03:52 PM

Try adding another IF function like this

=IF(AB12="POSTPONED",W12,IF(AB12="LOSE",W12*2,IF(AB12="WIN",0.1,Q12)))

**docrobo** · 10-09-2011, 04:16 PM

Hi daddylonglegs, your reply works perfectly. Many thanks.

**docrobo** · 10-23-2011, 03:50 PM

=IF(EZ12="WIN",EU12*EW12/EY12,IF(EZ12="POSTPONED",0,-EU12))

I have the above formula and I am wanting to ad the words "SEQUENCE END" to the formula so that it calculates the same as the word "WIN"

Can anyone help.