Share via

IF function help

Anonymous
2024-10-30T10:27:56+00:00

i am trying to use the IF function to look at a cell (say D6) if this cell equals Y then show another cell (say F6) as NA

i cannot get it to work , any suggestions?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2024-10-30T11:34:04+00:00

    A formula can only return a result in the cell that contains the formula, not in another cell.

    If you want to be able to enter data in F6 but have it change to "NA" if D6 contains "Y", that would require VBA code.

    This would work in the desktop version of Excel for Windows and Mac, not in other versions, and it would require users to allow macros.

    Would that be OK?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-10-30T11:12:11+00:00

    is there a way i can leave F6 to be left as a cell to enter information?

    does the if function need to be in the cell you want to show the result of the if query?

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2024-10-30T11:02:09+00:00

    Enter the following formula in F6:

    =IF(D6="Y", "NA", "")

    Was this answer helpful?

    0 comments
  4. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-10-30T11:01:49+00:00

    F6: =IF(D6="Y","NA","")

    Was this answer helpful?

    0 comments