Forum Discussion
Solved
Assistance with Performing Mathematical Formulas with 2 Parts
Hi everyone, I have a dataset that has a value (we'll say 2.1 million) and what I am looking to do is subtract out 3 million and then 20% of that value. Now I can do this by hand, but obviously, ...
is your data in 2 columns? I'm going to assume it is, and in column A and B.
you could use a formula like this:
=MAX(0,(A2-B2)*0.2)
or
MAX(0,(2100000-1500000)*0.2) = 120000
MAX(0,(2100000-3000000)*0.2) = 0
is your data in 2 columns? I'm going to assume it is, and in column A and B.
you could use a formula like this:
=MAX(0,(A2-B2)*0.2)
or
MAX(0,(2100000-1500000)*0.2) = 120000
MAX(0,(2100000-3000000)*0.2) = 0
Ah...
Philip West wrote:is your data in 2 columns? I'm going to assume it is, and in column A and B.
you could use a formula like this:
=MAX(0,(A2-B2)*0.2)
or
MAX(0,(2100000-1500000)*0.2) = 120000
MAX(0,(2100000-3000000)*0.2) = 0
I thought about using MAX but wasn't sure how to format it to get what I wanted. Let me try that and I will see if it works. Thank you.