+ Reply to Thread
Results 1 to 3 of 3

Logic for additional commentary

  1. #1
    Registered User
    Join Date
    01-19-2023
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    6

    Logic for additional commentary

    Hello
    I am working on KPI file and I want the primes to enter the commentary if the variance is less or more than the budget.
    if variance is less than the budget then they have to comment on what went wrong and how they will improve
    if variance is more than the budget, then they have to comment on what went good and how they will maintain.
    I am working in google sheet. Can someone please help?
    This commentary field is mandatory and we need them to fill in the details.sample workbook- google sheet.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: Logic for additional commentary

    Thread moved to Googlesheets sub-forum.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Logic for additional commentary

    "then they have to comment"
    how?
    where?


    Please give a much clearer explanation of what you are expecting for results.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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] Error Exceptions - help with additional logic to add formula errors
    By wherdzik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2023, 09:57 AM
  2. [SOLVED] Commentary and If statements
    By goldfield in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2019, 04:54 PM
  3. How would you add commentary to a pivot table?
    By Jamie100 in forum Excel General
    Replies: 1
    Last Post: 07-23-2017, 06:09 PM
  4. Appending Workbook data to a Master Workbook - additional logic needed
    By ajhardma in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2015, 01:50 AM
  5. [SOLVED] Need 401K formula with additional if logic
    By hmr2662 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2014, 02:48 AM
  6. Drop down menu with commentary
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-02-2014, 06:04 AM
  7. Mordred Banned Commentary
    By FortySixAndTwo in forum The Water Cooler
    Replies: 28
    Last Post: 08-31-2012, 03:09 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