different cell

  1. U

    Store sum to each cells in a column

    A1=2, A2=3. Then C1 should be the sum(2+3=5). But next time we change the values in A1 and B1 as "4","3" then the sum- 7 stored to B2, not B1. ....to B3. Thus the B1 not changing yet. What can do?
  2. K

    Same formula works in one cell but not another....

    Hi everyone, Wonder if anyone can help. I have the below formula which works fine. =SUM(IF(YEAR('Fixtures & Fittings'!$G3:$G65536)=INDEX!D$17,'Fixtures & Fittings'!$I3:$I65536,0)) However if I copy the formula into another cell it doesn't work? It is exactly the same formula but doesn't...
  3. R

    logic test output to seperate cell

    I am developing a sheet to do some debt analysis. I have an input cell for loan value (B1), interest rate (F1), term (months)(H1), and payment(J1). I also have a set of cells that will calculate each of these values individually, given the other 3 values (J4-7 respectively). What I am trying...
  4. G

    Can I do this in a formula, is VB needed?

    I'm setting up a form for people to enter information into. I have a free-form text field that users need to be able to type into, so I can't put a formula into it. However, I want a value to be "injected" into it upon a certain condition based on a formula from another cell "watching" that...
  5. K

    VBA output in a different cell

    I have a function and I want it to output one word in the current cell and one in the cell to the right (i.e., the next column). Is there a way to write this in VB? So, something along these lines (though this doesn't work): Function test(word1 As String, word2 As String) test = word1...

Watch MrExcel Video

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