Results 1 to 5 of 5

If Formula (IF this condition is met, then adjacent cell equals above cell)

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2019
    Location
    U.S.
    MS-Off Ver
    Excel 2016
    Posts
    70

    If Formula (IF this condition is met, then adjacent cell equals above cell)

    Hi,
    I'm developing a productivity app within Excel, and what I would like to do is have a happy face show up in the right adjacent cell whenever you type in an accomplishment.

    I'm pretty sure this can be accomplished with an IF formula, but I'm not familiar enough with the syntax.

    So I need the IF formula to do this: If there is any data in the "accomplishment entry cell" (D5), then something like: IF(D5>0) then (E5=E4)

    Any help would be greatly appreciated!

    Thanks,
    Bryan

    PS I've attached a file
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If a cell in a column equals today's date return the value of another cell adjacent to it
    By DeanExcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-24-2021, 01:38 AM
  2. Re: Copy and Paste row if cell equals condition
    By mattcass87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2018, 11:40 AM
  3. Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  4. Replies: 9
    Last Post: 09-30-2014, 09:10 AM
  5. Replies: 2
    Last Post: 03-24-2014, 06:02 PM
  6. Insert Column Adjacent to Cell If Cell Contents Anything Other Than Condition
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-20-2013, 03:45 PM
  7. Highlighting cell based on condition of adjacent cell
    By chris_stokes21 in forum Excel General
    Replies: 4
    Last Post: 09-13-2010, 07:44 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