Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Calculations 1

Status
Not open for further replies.

geoff337

IS-IT--Management
Dec 21, 2000
5
US
Is there a way to put a static number (say 250) in one cell somewhere on the worksheet and have a function or some equation add that number automatically to a number you enter into another cell? Say, type 2340.4 into a cell and, upon entering or exiting the cell, the program adds 250 to it automatically.

Uh...if there IS a way, would someone disclose please? Thanks a bunch. 'preciate it.

Jeff
 
Yes, I think this can be done. Unfortunately, I'm on the road until Friday and cannot get to my reference files. I can't store all this stuff in my head !!

If you can wait until Friday I'll look it up and send it on.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top