+ Reply to Thread
Results 1 to 3 of 3

How to stop cell's new value impact a formula result

  1. #1
    Registered User
    Join Date
    06-19-2017
    Location
    Azerbaijan
    MS-Off Ver
    2016
    Posts
    6

    How to stop cell's new value impact a formula result

    in A1 I have minutes (e.g 26), in B1 I have seconds (e.g 111). I want to keep seconds less than 60 in B1 and convert all 60 seconds to minute and add to A1. So I typed in A1 :
    = 26+QUOTIENT(B1, 60)
    It got value 27. Good. Then I typed in B1 :
    = MOD(B1, 60)
    It got value 51. Good. But as B1 value changed, A1 value also changed. Considering that, I will create new rows subsequently with corresponding values to minutes and seconds and will like to apply this process to them as well, what can I do? Is the only way manually to do the process (to write the QUOTIENT formula in appropriate row in A column and then strip off the formula and turn the cell's content into just value to prevent being impacted by B column cells' new values)?

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: How to stop cell's new value impact a formula result

    why not just use 2 new columns, that way you preserve your original data?
    c1=26+quotient(b1,60) or even c1=a1+quotient(b1,60)
    d1=mod(b1,60)

  3. #3
    Registered User
    Join Date
    06-19-2017
    Location
    Azerbaijan
    MS-Off Ver
    2016
    Posts
    6

    Re: How to stop cell's new value impact a formula result

    I just want to know the capabilities of Excel.

+ 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] Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2014, 11:33 PM
  2. Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  6. Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. Why doesn't the finance rate in MIRR impact the formula result?
    By opieandy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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