Creating a formula relating to several cells

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.
 
T

trip_to_tokyo

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.

=(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.
 
A

alanglloyd

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top