# different cell

1. ### 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. ### 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. ### 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. ### 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. ### 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...

### 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.

### Which adblocker are you using?

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

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