Multiple Mathmatical Calculations For Profit

Solved/Closed
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 5, 2021 at 11:51 AM
Awesome, thanks for the feedback!
0