Sep 03 2022 10:42 AM
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.
Sep 03 2022 12:34 PM - edited Sep 03 2022 12:34 PM
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
Sep 07 2022 09:30 AM
Thanks for your quick reply and answer.
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.
Sep 07 2022 11:33 AM
In your first post, you wrote "multiply with 0" - the result of that will always be 0.
Use this instead in D2:
=ALS(C2>0; C2/2; C2)
Sep 07 2022 11:31 PM