Formula Help - IF - asap??!! Thank you!

[lb1984]

Not a regular or very confident user of Excel (using 2003 at work) - have the following formula -

=IF(E4="ET",O4*$F$1,IF(E4="SR",N4*$F$1+$F$1/2, ))

Which is fine but want to add an addition IF and struggling! I want the formula to remain as above but include IF(E4="ETSR",O4*$F$1+N4*$F$1+$F$1/2)

Please help - I'm sure it is quite simple but it keeps erroring when I try!

Thank you thank you thank you!!

Laura

 

[prajul89]

=IF(E4="ET",O4*$F$1,IF(E4="SR",N4*$F$1+$F$1/2,IF(E4="ETSR",O4*$F$1+N4*$F$1+$F$1/2,FALSE)))


The False in the above formula represent when all the conditions are False.
You can change it according to your needs

 

[lb1984]

Thank you so much for your speedy response - so appreciated.