Previous Topic Next Topic

Multiple Mathmatical Calculations For Profit

Solved
Tom268
Posts
3
Registration date
Thursday July 29, 2021
Status
Member
Last seen
August 4, 2021
 - Jul 29, 2021 at 11:08 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 - Aug 5, 2021 at 11:51 AM
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

Answer 1 / 2
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 509
Aug 2, 2021 at 12:17 PM
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
Tom268
Posts
3
Registration date
Thursday July 29, 2021
Status
Member
Last seen
August 4, 2021
Aug 4, 2021 at 04:21 AM
Hi Trowa,

Thanks for getting back to me, appreciated.

That worked for me. Thank you.
0
Answer 2 / 2
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 509
Aug 5, 2021 at 11:51 AM
Awesome, thanks for the feedback!
0