+ Reply to Thread
Results 1 to 5 of 5

Help To Automate the Comment Row

  1. #1
    Registered User
    Join Date
    03-21-2022
    Location
    Botswana
    MS-Off Ver
    2010
    Posts
    14

    Help To Automate the Comment Row

    Please find an attached file, on it there's red painted cells with the further instructions.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,698

    Re: Help To Automate the Comment Row

    Hi,
    What is PWT NPWT POT NPOT?

  3. #3
    Registered User
    Join Date
    03-21-2022
    Location
    Botswana
    MS-Off Ver
    2010
    Posts
    14

    Re: Help To Automate the Comment Row

    Paid Within Target (PWT)
    Not Paid Within Target (NPWT)
    Paid Off Target (POT)
    Not Paid Off Target (NPOT)

    Belinda

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,698

    Re: Help To Automate the Comment Row

    hi,
    is this giving you the required result?

    G2 and down:
    =IF(TODAY()-E2<=14,"PWT",IF(AND(TODAY()-E2<=14,F2=""),"NWPT",IF(TODAY()-E2>14,"POT",IF(AND(TODAY()-E2>14,F2=""),"NPOT"))))

  5. #5
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,698

    Re: Help To Automate the Comment Row

    Or perhaps this one, if PWT and POT are calculated on column "F":

    =IF(F2<=14,"PWT",IF(AND(TODAY()-E2<=14,F2=""),"NWPT",IF(F2>14,"POT",IF(AND(TODAY()-E2>14,F2=""),"NPOT"))))

+ 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. Force Comment when Condition Met. Comment appears on the wrong cell.
    By annap0tchi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2020, 04:58 AM
  2. Excel Macro to Insert a Comment and add a Picture to the Comment
    By TheMechEngineer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-12-2019, 05:01 PM
  3. [SOLVED] Function to return comment from a cell, or null string if no comment
    By Monkihunta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2017, 01:01 PM
  4. Check if cell in range is empty, if it is delete comment else format comment to
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2015, 01:15 AM
  5. Copy contents of multiple comment boxes and paste in a single comment box
    By xxJaRxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2014, 12:39 PM
  6. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  7. Replies: 0
    Last Post: 09-04-2008, 01:35 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