+ Reply to Thread
Results 1 to 2 of 2

Replacing cell after calculation

  1. #1
    Registered User
    Join Date
    12-31-2011
    Location
    las vegas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Replacing cell after calculation

    I have a number in F1, say 500. In K1 I put in a number like 4.7, that is today's percentage, (it changes 2 or 3 times per week) What I'm trying to do is to multiply 500 by 4.7%, then put that number 523.5 back into F1. I have played with F1*(1*(k1%))+F1 but get an error. I played with "Range". I decided to ask for help before I just give up!!

    Thank You
    WKRJ

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,923

    Re: Replacing cell after calculation

    Try this code

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. [SOLVED] Age calculation to today formula calculation error - in a single cell [Excel 2016]
    By NigeJG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2023, 04:09 AM
  2. [SOLVED] Calculation of dates and leaving blank cell when calculation sees non-date values
    By Hedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2018, 07:52 AM
  3. Replacing strings/ replacing numbers and letters
    By Insert Name in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2015, 01:15 PM
  4. Replies: 1
    Last Post: 01-28-2015, 05:12 PM
  5. Replacing cell value without replacing formula in the cell
    By kingoftheace in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2012, 06:28 AM
  6. Add an amount from a calculation to a cell with a calculation (Sample attached)
    By aiwnjoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2010, 10:41 AM
  7. Replacing Subproduct - Slow Calculation
    By S_P_A_R_K_S in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2008, 12:41 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