Forum Discussion

dirarick's avatar
dirarick
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 with the rest of the formula.  So here is the gist.  I have column D is the number of orders I received, which is multiplied by the absolute 16.95 (M2)(the cost of said item), then if they are choosing to add choices E and F (they cost $2 each), then the entire total is then multiplied, etc to the ending absolute (M3).

=(($D9*$M$2)*(1+$M$3))

excel
  • mtarler's avatar
    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)

     

5 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    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)

     

      • mtarler's avatar
        mtarler
        Silver Contributor
        Jun 20, 2020
        Glad it helped. Feel free to mark best answer because I think it help 'close' the thread
  • hynguyen's avatar
    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)

     

Resources