Results 1 to 4 of 4

Combining 3 formula's in one cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    South Africa
    MS-Off Ver
    Excel 365
    Posts
    44

    Combining 3 formula's in one cell

    HI all,

    Please could you help me I've got a spreadsheet with the following formulas that I want to implement:

    =INT((TODAY()-E2)/7))
    =IF(ISBLANK(E2),""
    =IF (L2=”ARRIVED”, "",

    Basically, I want the cell to calculate how many weeks between today and the date in cell E2. If cell E2 is blank, then I want the current cell to stay blank. ALSO, if cell L2 has the word "ARRIVED", then I want the cell to stay blank. How do I combine all 3 formula's into one cell?

    Would really appreciate your help! THanks!
    Last edited by Cutter; 07-27-2012 at 09:43 AM. Reason: Corrected title

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