View original (French)

Function numbers

LandryCarpentras Posted messages 9 Status Member -  
 Anonymous user -
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 Posted messages 9 Status Member
       
      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
      1. LandryCarpentras Posted messages 9 Status Member > Anonymous user
         
        It 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 Posted messages 9 Status Member
     
    it's really my touch / that's messing up
    0
  4. 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