Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel function (https://www.askmehelpdesk.com/showthread.php?t=156998)

  • Nov 28, 2007, 02:57 PM
    claired
    Excel function
    I am looking for a formula that allows me to have a specific text if the value in the cell selected is between 19xx and 19yy. I thought of using IF but can't figure it out... :(
    If the value is greater than 1967 and less than 1977 value = 30s
  • Dec 2, 2007, 04:26 AM
    Duane in Japan
    Nested IFs

    Look around this site if this link is not exact or close to what you need.

    • All times are GMT -7. The time now is 10:15 PM.