shortening

  1. J

    Help in shortening excel formula

    Hello helpful souls, I have just signed up here to learn the wonders of Microsoft Excel and a complete total noob. I just want to ask for help in shortening my formula: =IF(D10="Yes",C10)+IF(D11="Yes",C11)+IF(D12="Yes",C12)+IF(D13="Yes",C13)+IF(D14="Yes",C14)+IF(D15="Yes",C15) and so...
  2. S

    Easier way to write this SUM formula?

    I was wondering if there was a shortened, more efficient way of writing this formula =SUM(C16*G16,C17*G17,C18*G18,C19*G19,C20*G20,C21*G21,C22*G22,C23*G23,C24*G24,C25*G25,C26*G26,C27*G27,C28*G28,C29*G29,C30*G30,C31*G31,C32*G32) Any help is appreciated, Thanks
  3. C

    Shortening IF formulas

    I am not sure if this has already been posted somewhere, as I could not see anything similar. So apologies if I am asking a repeated question. I am trying to use a nested IF formula to return certain results in a cell, but the problem is that I am being told the formula is too long. Is there...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top