Creating a formula relating to several cells

  • Thread starter Thread starter Lexigist
  • Start date Start date
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.
 
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.
Click to expand...

=(A2*10%)

The above will work out the value of 10% in cell A2.

Change the cell reference number to the one required.

If my comments have helped please rate my posting (if possible).

Thanks.
 
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.
Click to expand...

As only _one_ cell will have anything in to calculate, simply sum the
cells & take 10% of that sum.

=SUM(A2:A3)*10%

The result against the cells with nothing in will, of course, return
0.

If you dont want the zeros to show, then format all the cells in the
result column as #0;#0,"". Or if you want 2 decimal places
#0.00;#0.00;"".

To format the cells, select them & right-click in the selection,
choose Format Cells, click on Custom and enter the format definition
above.

Alan Lloyd
 
Back
Top