Forum Discussion

CarlS2295's avatar
CarlS2295
Copper Contributor
Oct 11, 2024

value

in Excel for mac, how can I increase cell value by 1?

9 Replies

  • Eniola-Adekoya1's avatar
    Eniola-Adekoya1
    Copper Contributor

    CarlS2295 

    Your question is not really clear .but  i figure this is what you are asking.
    below is an image. type 1 on a cell ,copy the 1 ,highlight the cell that requires the addition go to paste special and click on add then ok.

     

     

  • mathetes's avatar
    mathetes
    Gold Contributor
    How does the value get there in the first place? Add 1 to whatever the formula is.

    But basically, what I'm saying is you need to give us a bit more context. The answer seems so obvious that it's hard to understand why you're even asking, and finding out that requires you to tell us more,
    • CarlS2295's avatar
      CarlS2295
      Copper Contributor
      Duh! True, false cells dynamic & "copy" creates new true, false. Ok if row member of separate table entries but need "$" if row member subsequent iteration.. Thank you.
      • mathetes's avatar
        mathetes
        Gold Contributor
        OK. I think your explanation needs an explanation. I'm sure it's clear to you, but reading it makes me feel as if I've dropped in on the middle of a technical conversation and missed all that had gone before.

Resources