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