98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function
IF function
Resolved · Low Priority · Version 2007
Wed 17 Jun 2009, 15:34Delegate Dimitrios said...
Dimitrios has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
IF function
How can you put a two boundary condition in a nested if function, i.e. how can someone put a < and > sign for the first check, insteda of just < or >? For example, somebody may want to iognore all values that are greater than 100 and say that the first check in the nested if function must be if Cell X is between value Y and Z then for that, if (...) do that and so on and so forth.
Thu 18 Jun 2009, 14:05Trainer Amanda said...
RE: IF function
Hello Dimitrios
Thank you for your question and welcome to the forum.
I think you would need to use an AND function as part of the logical test argument (first part) of the function. For example, if I wanted Excel to check if the value in cell X is greater than Y but also less than Z:
=if(and(X>Y),(X<Z),....
so the value in cell X would need to meet both conditions (be greater than value Y but also less than value Z) in order for Excel to then enter the 'value if true' (second part) of the function into the cell for you.
I hope this helps.
Kind regards
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using the Quick Access Toolbar in Excel2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
