Copper Contributor

Hi Guys,

I am trying to create a formula that if D1 is greater than 0 (when i make a profit) it needs to multiply with 0,5 (so half will go to my savings and half will be added to the existing). If D1 is lower than 0 (if i make a loss) it needs to multiply with 0, so the full loss is taken into account.

I have played arround with the ALS function, but that wasnt succesful for me.

Hope you guys know a great solution.

4 Replies

In your screenshot, D1 does not contain a number. Did you mean C2? If so, enter the following formula in D2 (or another cell in row 2), then fill down:

=MAX(C2/2;0)

or (equivalently)

=MAX(C2;0)/2

The answer covers party wat I was after, maybe it was a little unclear in my first explination so Ill try to be more clearly. In the attaced picture I have added the D section (with the results I want to achieve). What I want to achieve with a formula is 50% of my Profit and a 100% of my loss.

In your first post, you wrote "multiply with 0" - the result of that will always be 0.