+ Reply to Thread
Results 1 to 3 of 3

execute a function with a cell that already had a value

  1. #1
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    execute a function with a cell that already had a value

    Hello,

    This may sound a stupid question. I wonder if I can do a simple function in a cell that already had a value without deleting the value. For example, I have cell A1 = 50.. I want to do a multiply function in cell A1 . I want to get 50* 5 in cell A1, how can I do that without jeopadizing the value already in the cell. You may suggest me why not type = 50*5, imagine I have a spreadsheet will all the data filled in and all I want is get all those numbers multiply for 5 in the same cell to display a new result.

    I may not explain well, appreaciate any inputs or thoughts

  2. #2
    Registered User
    Join Date
    09-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: execute a function with a cell that already had a value

    Type 5 off to the side. Copy the 5, then paste special - multiply across all of those target cells. That will multiply everything by 5. (You can delete the random 5 after). Hope that's what you were looking for!

  3. #3
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Re: execute a function with a cell that already had a value

    Oh man, You are such a huge help. Thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF cell=error execute sub 1 if value execute sub 2... possible?
    By CDNcameron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2013, 05:28 PM
  2. VBA Function will not execute.
    By danleonida in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-20-2012, 04:46 PM
  3. how to execute a function only if it's possible?
    By marlonsaveri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2011, 08:28 PM
  4. re-execute vba function
    By Nader in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2006, 02:25 PM
  5. Replies: 1
    Last Post: 12-06-2005, 09:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1