+ Reply to Thread
Results 1 to 4 of 4

Formula in cell cell based on another cell.

  1. #1
    Registered User
    Join Date
    02-18-2021
    Location
    Bamber Bridge
    MS-Off Ver
    Microsoft 365
    Posts
    17

    Formula in cell cell based on another cell.

    Hi,
    I am trying to write a formula in a cell based on another cell. Basically is it possible?
    I have a cell that I want to display enter Y or N, then depending on what you input the cell states 2 out comes. The below formula is in cell $D2 but I really need the formula in $D3 in order to work but of course it can't be because when I input the Y or N in cell $D3 it will delete the formula. Is there away of doing this?
    Any help will be appreciated.

    =IF(ISBLANK($D3),"Enter Y or N",IF($D3="y","Taken",IF($D3="n","Not Taken?","errr!")))

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Formula in cell cell based on another cell.

    No - the formula will need to be in a separate cell - as you say, entering the Y/N would over-write the formula. You could try to disguise it with formatting. You could set the Y/N as a drop down in with Data validation

    Is there a reason you can't have 2 cells?
    If this solves your issue, Mark thread as Solved & Add Reputation.

    Thanks!

  3. #3
    Registered User
    Join Date
    02-18-2021
    Location
    Bamber Bridge
    MS-Off Ver
    Microsoft 365
    Posts
    17
    Hi,
    Thanks for replying, there’s no reason why 2 cells can’t be used in fact I have done it that way, I was just wondering if there was a way around doing what I required just to make it look good and to shrink the size of the sheet.
    Kevin.

  4. #4
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Formula in cell cell based on another cell.

    Your other option is VBA - fill the Y/N column then have it step through and add the formula over the Y/N column

+ 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. Macro: Formula that pulls data from a specific cell based on another cell?
    By EdgarV97 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-06-2019, 02:01 PM
  2. Replies: 5
    Last Post: 11-19-2018, 01:52 AM
  3. [SOLVED] Conditional Formatting formula to color one cell based on a date range in another cell
    By katiedee1625 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2018, 08:52 AM
  4. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  5. [SOLVED] Formula to create a blank cell based on a dollar amount in another cell.
    By avidcat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2014, 02:11 AM
  6. [SOLVED] Formula to fill a cell based on drop down list in previous cell
    By formatting freak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2013, 01:18 AM
  7. [SOLVED] Cell Formula reference to cell Based On third Cell Content
    By Gabriel in forum Excel General
    Replies: 0
    Last Post: 02-11-2005, 02:06 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