Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
IF Formula Help Please
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="T. Valko, post: 3779354"] It depends on which set of conditions should have precedence. The way you have the formula written: takes precedence over everything else. Does that mean if *every* cell in that range =S? Try putting this test first: =IF(AND(AG2:AN2="S"),"G",IF(AND(AG2="S",AH2="S"),"Y",.............) [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
IF Formula Help Please
Top
