Results 1 to 3 of 3

Formula help requiring two variables

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Formula help requiring two variables

    Is anyone good at formula's for Excel. I have been struggling with one for about half a hour now (not used formulas in a long time and only to a basic level)

    Basically I want a formula that will tell me if cell A is X or Y and then if its X if the date in cell B is 3 years ago but if its Y it needs to tell me if its 5 years ago. Is this possible?

    So far I have only got a formula using the AND function that will tell me if Cell A is X or Y and if it is 3 years ago.
    Last edited by isimba; 09-10-2012 at 10:47 AM.

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