Forum Discussion
ALS function advanced
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)....
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.
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)
- HansVogelaar
Correct this is been my mistake.
The formula provided works perfectly! Many thanks for your help.