plus 1

  1. Jyggalag

    Make VBA code that posts a cells formula as a value

    Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...
    • Jyggalag
    • Thread
    • christian røssel code excel ezzzzzzzzzzzz fast formula goldstrome help hlookup jonas sværke lookup minus olzenmedz plus 1 sum sumproduct vba vlookup xlookup
    • Replies: 1
    • Forum: Excel Questions
  2. D

    + and - (plus and minus) in Excel list

    Hello everybody, I am currently currently managing a stock overview in Excel (manually), where I have a set quantity. I want to create two columns next to my quantity column where I can enter numbers that should be substracted and added to the quantity, so it looks like this: Now obviously I...
    • David77
    • Thread
    • excel formula minus plus 1 stock stock administration stock allocation stock analysis
    • Replies: 2
    • Forum: Excel Questions
  3. C

    Plus one to C1 IF A1 = Yes

    Hi Guys! So basically as the title suggests I want to add 1 to the contents of Cell C1 if A1 = yes. the concept is to count how many times a cell is switched to "Yes" and have a cell (C1) record every time it changes back to it. Hope that makes sense guys. Cheers

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