+ Reply to Thread
Results 1 to 4 of 4

Noob Needs Help Writing a Formula

  1. #1
    Registered User
    Join Date
    04-06-2017
    Location
    Yorkshire
    MS-Off Ver
    365
    Posts
    1

    Question Noob Needs Help Writing a Formula

    Hi Guys

    Very new to excel.

    I need a formula that says

    if B8 has a date, then fill E8 with a date of +28 days (Also) If B8 says Arrived turn E8 Green (I assume this bit would be formatting).

    Please can someone advise

    Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Noob Needs Help Writing a Formula

    Hi,

    The formula for E8:

    Please Login or Register  to view this content.
    The conditional formatting formula for E8:

    Please Login or Register  to view this content.
    Hope this works for you and is helpful.

    Cheers

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Noob Needs Help Writing a Formula

    I think for CF: =B8="arrived"

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: Noob Needs Help Writing a Formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ 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] Noob: don't know how to write IF statements for =mid formula (simple code)
    By lougs7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-19-2015, 11:43 AM
  2. Looking For A Formula - Noob
    By d4funky1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2015, 08:35 AM
  3. [SOLVED] Excel Noob Needs Help With a Formula!
    By Drew Pickles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2014, 10:21 PM
  4. [SOLVED] Noob To R1C1 format, New Formula Received and I Need Help Please.
    By DHartwig35805 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2013, 04:04 PM
  5. Noob question - How to edit a formula across workbooks - shortcut?
    By webbt01 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-04-2012, 07:45 PM
  6. [SOLVED] Conditional Formatting Formula needed for noob
    By Patrick Byrne in forum Excel General
    Replies: 1
    Last Post: 04-04-2012, 05:48 PM
  7. Noob help with a formula
    By tmmgem in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-12-2008, 03:03 PM

Tags for this Thread

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