Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Raju Iyer   on Feb 07 In MS Office Category.

  
Question Answered By: Bonnie Hughes   on Feb 07

You must to write  the formula:

=Or(IF(F9=($D$9:$D$608),True,False))
Formula 1

True and False without “”

and then, before to press Enter, press Ctrl+Shift+Enter in the cell with the
formula. Excel will automatically add the braces.

{=Or(IF(F9=($D$9:$D$608),True,False))}
Formula 2

If you write the Formula 1 the result will return True if F9 has the same value
that any value in the range $D$9:$D$608 and the other hand this will return
False.

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on "If/Then" statement in Excel Or get search suggestion and latest updates.


Tagged: