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

Question

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

Input_PPC_NET_PLUS.xlsx

Output_PPC_Net_Plus.xlsx

abacon · Accepted Answer

@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 Answer

Hi,

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

Many thanks again!

Monica