+ Reply to Thread
Results 1 to 4 of 4

Help with NOW() Formula to vary results in different cells

  1. #1
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Help with NOW() Formula to vary results in different cells

    I am using a formula like this:
    IN CELL B1 =IF(A1>0;NOW();0)
    IN CELL B2 =IF(A2>0;NOW();0)
    IN CELL B3 =IF(A3>0;NOW();0)
    And so on...

    And "A:A" has various calculations that return a number.

    The problem I run into is, when ONE of the "B:B" cells returns a Date/Time result, they all return the same exact Date/Time result. But I'm trying to get different date/time results row by row. So, how do I get individual results?... if there is no other way besides VBA, then please provide a VBA for me.

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Help with NOW() Formula to vary results in different cells

    Hi nenadmail,

    the now() function will return the actual value, whenever data is recalculated - which typically happens for the whole worksheet at a time. What time would you expect in B1 to Bx? SHould B3 show the time when A3 was changed?

    Regards

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Re: Help with NOW() Formula to vary results in different cells

    ok so it seems that the NOW() function is not going to solve my needs. I need it to be more by individual cells, not for the whole worksheet.

    Exactly what you said is what I need:
    SHould B3 show the time when A3 was changed?
    My answer: YES

    ---------- Post added at 02:26 PM ---------- Previous post was at 02:11 PM ----------

    By the way... in my original formula example:
    =IF(A1>0;NOW();0)

    The "if false" result ";0)" is something I put because I didn't know better at the time, sorry. Rather it should be "C1")

    Correction:
    =IF(A1>0;NOW();C1)
    =IF(A2>0;NOW();C2)
    =IF(A3>0;NOW();C3)
    and so forth...

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help with NOW() Formula to vary results in different cells

    Hi,

    You will need a macro, specifically the Sheet Change macro:


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A:A")) Is Nothing Then Target.Cells(1, 2) = Now
    End Sub
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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