How to express multiple IF Statement

[ddub25]

Hello

I have attached a file showing a few simplified rows of my sports betting spreadsheet. In column N I have a formula which calculates the profit returned from each bet considering whether the bet was a 'win', 'lose' or 'void' and whether any commision will be charged.

The formula takes into account whether the bet was placed with BF or BQ, and if so minuses 5% commision from the profit. If the bet was placed with any other bookmaker, no commision is minused.

My problem is trying to express the formula to include 'win 0.5', 'lose 0.5' and 'draw'. On the 3rd bet example where the bet won half profit, the profit should be £36. I have manually entered this figure because everytime I try to express the formula to incorporate 'win 0.5' it says formula error. I have the same problem trying to incorporate 'lose 0.5' and 'draw'.

If anyone can help with this formula it would be much appreciated. Thanks in advance.

Dan