Forum Discussion
Assistance with Performing Mathematical Formulas with 2 Parts
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
You sir, have saved my fingers. That did the trick. I am very thankful. I wasn't sure it was possible to be honest, I am pretty good at Excel (my job has a bunch of classes on it) and this has broadened my horizons.
Thank you again,
Brendan
Super!
Glad it worked.
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.
