Function numbers
LandryCarpentras
Posted messages
9
Status
Membre
-
Anonymous user -
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
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 réponses
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.
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.
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.
So, as I was saying, take a screenshot similar to mine and put it here.
https://www.commentcamarche.net/infos/25913-ccm-inserer-une-image-dans-une-discussion/