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
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.