View original (French)

Function numbers

LandryCarpentras -  
Hello, I would like to create a formula in Numbers 4.2, a percentage increase formula for revenue
in Excel I type:
=(C4-B4)/B4 *100

I can't translate this simple function to compare revenue with last year

If someone can help me

4 answers

  1. Anonymous user
    Good evening,
    you must be making a typo. There is no particular problem:



    --
    Always provide your system configuration completely - exact model of the computer, exact OS version.
    0
    1. LandryCarpentras Author
      It tells me that I have a syntax error.
      0
    2. Anonymous user
      At the bottom of my screenshot, we can see the syntax used.

      Note that in your earlier request, you wrote:

      =(C4-B4)/B4 *100

      but it would be better to write:

      =(C4-B4)/B4*100

      That said, it didn't have any impact on my end.

      If you take a screenshot similar to mine, we should be able to find the issue.
      0
    3. LandryCarpentras Author
      @Anonymous userIt works on my iPad and not on my computer, I think I have a problem with my keyboard, because when I press the / key, my computer types a + every other time. I thought I was hitting the wrong key since they're next to each other, but no.
      0
  3. LandryCarpentras Author
    it's really my touch / that's messing up
    0
    1. Anonymous user
      What you put cannot be correct, you are just giving a range of values between b5 and c5, and nothing more, so obviously you have this error message:



      since Numbers does not know what to do with this range

      but if I set a formula that means something it works, for example b5/c5



      or even what I had put earlier in my first response...

      --
      Always indicate your system configuration completely - exact model of the computer, exact OS version.
      0