Results 1 to 6 of 6

If/then, reference cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2019
    Location
    Pensacola
    MS-Off Ver
    2013
    Posts
    10

    If/then, reference cell

    (Excel 2013)

    Hi,

    I want to reference different cells in a table based on certain criteria: ex. If "insert numeric age" is less than 60, then (cell reference), however if age is greater than 60 but less than 76, (cell reference), if age is greater than 70, (cell reference).

    Hope that makes sense.

    Basically I want to enter a date of birth on my spread sheet (I already have a formula to calculate the age) and then use that age to determine the "full retirement age" of that individual based on a table elsewhere in the spreadsheet.

    Thanks in advance!

    (see attachment for more context)
    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. Replies: 1
    Last Post: 08-14-2015, 02:49 AM
  2. Indirect Sheet reference with cell reference left function and text
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:31 AM
  3. Replies: 1
    Last Post: 02-11-2015, 01:56 PM
  4. [SOLVED] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  5. Replies: 5
    Last Post: 02-25-2010, 03:51 PM
  6. Replies: 3
    Last Post: 05-13-2009, 11:51 PM
  7. Text Cell reference and increase the cell reference by step value
    By Supriya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2005, 08:18 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