ADDING 30000 TO A CELL

C

CONFUSED

I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY CELL
THAT I NEED TO ADD 30000 TO?
 
S

Sheeloo

Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit->Paste Special->Add
 
C

CONFUSED

THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I NEED
TO ADD 30000 TO. THANKS THOUGH
 
T

T. Valko

Try it like this:

Enter 30000 in an empty cell
With that cell still selected, copy that cell: Edit>Copy
Select the range of cells you want to add the 30000 to
Then: Edit>Paste Special>Add>OK
Delete the cell with 30000
 
C

CONFUSED

NOW I COME BACK WITH AN #REF ERROR?

T. Valko said:
Try it like this:

Enter 30000 in an empty cell
With that cell still selected, copy that cell: Edit>Copy
Select the range of cells you want to add the 30000 to
Then: Edit>Paste Special>Add>OK
Delete the cell with 30000
Click to expand...
 
S

Sheeloo

I amsorry I forgot to tell you to copy the cell containing 30000 before
PASTE SPECIAL...

As also suggested by Valko you should get what you want (adding 30,000 to
the cells you want)

I have tested it and it works...

Do you have any cells with formula in the range you are pasting?...
If your cells are not adjacent to each other then use CTRL-Click to select
one by one...
 
Top