IF function

The UK's most regular instructor-led training courses.
Training information: excel training course · Excel advanced · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

2 posts

ReplyWed 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.

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyThu 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

· Simple Ways To Customise Excel
· What's Better Than the Help Function in Excel? Microsoft Training
· Customized Financial Excel Courses in London
· Importing Useful Information From The Web To Excel
· Securing Critical Company Information With Simple Visual Basic Training Courses

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips