Hi just trying to figure out how to write a formula.

Example.ods (10.5 KB)

So I just want to combine the 6 formulas into 1 but I am getting stuck. As I am new to spreadsheets I am not even sure if the IF function is what I should be using. I think what I am trying to do is “Test” if results are true or false then do a simple calculation and output the answer to profits. Then I guess once the first row is correct I can just auto fill the rest.

I have tried IF and OR and SUM and SUMIF and they seem somewhat work but not in their entirety.

I think there are a few ways to go about it so I am sort of going around in circles

```
//* =IF(L2="Bonus Back",(J2*K2)*0) *//
//* =IF(L2="Bonus Win",J2*K2) *//
//* =IF(L2="Loss",(J2*K2)*-1) *//
//* =IF(L2="No Result",(J2*K2)*0) *//
//* =IF(L2="Placed",(J2*K2)-K2) *//
//* =IF(L2="Win",(J2*K2)-K2) *//
```

So I tried

` =IF(OR(IF(L2="Bonus Back",(J2*K2)*0),IF(L2="Bonus Win",J2*K2),IF(L2="Loss",(J2*K2)*-1),IF(L2="No Result",(J2*K2)*0),IF(L2="Placed",(J2*K2)-K2),IF(L2="Win",(J2*K2)-K2)))`

but it doesn’t seem correct.

Any help is greatly appreciated

Thank you

Isaac

Version: 7.4.2.3 (x64) / LibreOffice Community

Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf

CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win

Locale: en-AU (en_AU); UI: en-GB

Calc: CL