How to get a substraction...seems very simple but cannot get it

[maxtla]

HI,

thanks for reading my email.

I have to get 2 calculations:

PPC Net = Lever (PPC) - Market Effects (LRMI) - Market Effects (CTR) = (7500) - (1749) - (10233) = 4482

PPC Net Plus =  (PPC) - Market Effects (LRMI) - Market Effects (CTR) - Market Effects (Steel) = (7500) - (1749) - (10233) - 211 = 4271

In the attach you will find the excel file how is without (input) and with (output) calculations. 

will appreciate any help.

best regards

[abacon · Accepted solution]

@maxtla Here is a way to do it.

Instead of trying to do the calcs across rows, normalize the table to be one record per calculation, break out the columns so you can easily create a formula for each calc above. You can mess with decimal places and desired output in terms of columns and setup, but here you go on the calcs.

Bacon

[maxtla · Accepted solution]

Hi,

Thank you very much for your solution!! you are my hero. Is working perfectly!

Many thanks again!

Monica