e15

  1. L

    VBA to delete cell contents based upon another

    Hello everyone. I have been searching through the forums looking for an example to delete the contents of a cell based upon the value in another but cannot seem to get it to work. What I have is a spreadsheet that in A15 if it is blank, I would like to have E15 to delete it's contents. If A15 is...
  2. T

    Excel complex formula for me..

    Hi All, Couple of things i havent been able to get sorted out yet, first if C15 is 50 or less add 1 to D15 and 2 to E15, or if C15 is =51 <75 add 1 to D15 and 3 to E15, etc.. 2nd if O2 or R2 is Purple,Orange,teal or aqua and H2 is red add(Sheet2-C15 to sheet1-F17),green add(Sheet2-D15 to...
  3. B

    Wrong formula

    I have this formula and I cannot get it to work for me =IF(E11="",0,SUM(F6:M6,B11:E11)) the cell which the formula is in is E15, so if E11 has no value then I want E15 to be "0",, If E11 has a value then the formual SUM(F6:M6,B11:E11) needs to apply. Thank you. E6 5,000 E11 0 E15 0 E6...
  4. B

    Cell to be 0

    Hello, I have this formula =IF(E11="","",SUM(F6:M6,B11:E11)) which works, but the cell the formula appears in is E15 What i am trying to do is that if cell E11 have no value in then cell E15 to be "0", the formula I have works when E11 has a value in it adds to E15 ok. But I need E15 to be...

This Week's Hot Topics

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
Top