excel-droid

for example

look at this picture

HI SIR

i want function from Excel addition all cells from column A to column B .meaning is every cell in column A add 24 times(24 cells in column B).

i want  function from Excel selected  rows that are the same result equal.

what's the function in excel or speed way to addition one cell to other column cells.

such as

=7+10

=7+11

=7+12

...etc

afte that"

=8+10

=8+11

=8+12 ..etc

after that

=9+10

=9+11

=9+12..etc

>>>to final cell

any body can i help me about this question ?

thank u very much (Genius*Creative*super clever =Alan).

thank u very much (Genius*Creative=Alan)

I have done this way and actually succeeded.

But the problem is if the number is up to 100, so that Excel 2013 sometimes does not accept more than 20 or 14 number in one cell.

Example:
5124536552325647895698745789654789654
(Not possible in Excel to show this number)
-
12
= #NUM (this code sometimes appears when a significant number ).

I want the code for Visual Basic in Excel so that you can subtract any number, even up to 1000 number from a smaller number.

many thanks Alan

it's right.

How do I put code in Visual Basic in Excel by this function ( mod )
The first box: any number
The second box: small number (4,7,12)
The third box: result .