Multiple Mathmatical Calculations For Profit

[Solved]
Report
Posts
3
Registration date
Thursday July 29, 2021
Status
Member
Last seen
August 4, 2021
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hi,

I'm trying figure out how to create a formula to calculate profit from a row with multiple options.

column n*o=a
column p=b
column q=c
column r=d
column s=e
Profit = (either; a subtract d subtract e OR b subtract d subtract e OR c subtract d subtract e)

I'm not sure if this is possible

Hopefully I have explained it properly.

Any help would be appreciated.

2 replies

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Tom,

How do we know if the profit is 'a - d - e' or 'b - d - e' or 'c - d - e'?

When it's 'a - d - e', shouldn't the formula simply be: =(N2*O2)-R2-S2 ?

What am I missing here?

Best regards,
Trowa
1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2821 users have said thank you to us this month

Posts
3
Registration date
Thursday July 29, 2021
Status
Member
Last seen
August 4, 2021

Hi Trowa,

Thanks for getting back to me, appreciated.

That worked for me. Thank you.
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Awesome, thanks for the feedback!