=A3/$B$2 and copy down. Denominator in B2
Pressing F4 while clicked on B2 (in the formula) will cycle through the
$ options. I think of the $ as "freeze" or "lock".
Freeze column at B, freeze row at 2
On 03/10/2019 12:00, Gilles wrote:
> Hello,
>
> Another newbie question: I need to show percenta
At 16:00 02/10/2019 -0700, Gilles Noname wrote:
Another newbie question: I need to show
percentages in columns. This involves using a
relative cell as numerator, and an absolute cell
as denominator. [...] I tried adding $
1. in
the first cell: NOK. 2. in the second cell: NOK.
How can I apply
Hello,
Another newbie question: I need to show percentages in columns.
This involves using a relative cell as numerator, and an absolute cell as
denominator.
https://postimg.cc/G9tccRmV
I tried adding $…
1. in the first cell: NOK.
2. in the second cell: NOK.
How can I apply the formula to all