View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default ADDING 30000 TO A CELL


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

"CONFUSED" wrote:

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?