divide if

  1. C

    As IF, I just can't get it right. If need to Add and Divide in the Formula

    I'm trying to design a spread sheet I will also uses as a display. I am wanting to add the row, but if the cell under if says "Half" I want it to divide the number above by 2 then add it. So in my picture B4 is 1 but since B5 says Half I want it to add as .5 will C4 still adds as 2 in U4. So U4...
  2. E

    Conditional divide (divide if)

    B C D 10 1 5 8 0 6 4 1 4 This is a short version of my sheet. Column C only contains 1 or 0. Column B and D all sorts of numeric values. For each cell in column A I want to check if the corresponding cell in column C contains a 1 and if so, I want it to divide the...

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