Forum Discussion

Copper Contributor

Jun 19, 2020

Solved

Excel formula

I need help with an excel formula. This is what I have right now, but I need to add something after ) and before *. It needs to total the next two columns EF and multiply them by 2.00 then continue...

excel

mtarler
Jun 20, 2020
dirarickI think I get what you want. It should just be another term like the following (based on row 9 as was your example):
=(($D9*$M$2)+(E9+F9)*2)*(1+$M$3)

hynguyen

Iron Contributor

Jun 19, 2020

dirarick It would be easier if you can provide an example of your desired outcome with your mock inputs. Is M3 where you want to calculate the final cost of everything or only the add-on E and F? Are E and F the quantity of add-on order? Are E and F dependent on D? Can you attach a screenshot of your mock inputs in D, E and F and M2 then what your manual calculation of your final result is?

I assume M3 is where you want your total is so my formula in M3 would be:

=D10*$M$2+2*SUM(E10:F10)

dirarick
Copper Contributor
Jun 20, 2020