L
Lexigist
Hi!, Thank you for listening. A comparatively simple problem but I
can't get it!
The formula should be, for example in Cell A1, to calculate 10% of the
amount in cell A2 or A3 or A4 or A5 etc.
I can work it for one cell =sum(a2/11) - no problem, but when I wish
to include other cells (only one cell at a time will have a value ie
A2 OR A3 etc, I can't figure it out. I tried using =sum(A2/11) or
(A2/11, A3/11. A4/11) but that didn't work. I also tried
=sum(a2/11)*or(a2/11,A3/11) etc as the computer recommended. Can
someone help please? Thank you.
can't get it!
The formula should be, for example in Cell A1, to calculate 10% of the
amount in cell A2 or A3 or A4 or A5 etc.
I can work it for one cell =sum(a2/11) - no problem, but when I wish
to include other cells (only one cell at a time will have a value ie
A2 OR A3 etc, I can't figure it out. I tried using =sum(A2/11) or
(A2/11, A3/11. A4/11) but that didn't work. I also tried
=sum(a2/11)*or(a2/11,A3/11) etc as the computer recommended. Can
someone help please? Thank you.