The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

IF function

Resolved · Low Priority · Version 2007

ReplyWed 17 Jun 2009, 15:34Delegate Dimitrios said...

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.

For upcoming training course dates see: Pricing & availability

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

Excel articles

· Creating Tables Automatically In Excel 2010
· How To Use Filtering In Excel 2010
· How To Create An Argument With Excel
· How To Create A Simple Currency Convertor In Excel 2010
· Microsoft Office and the Small Business: Part 1 Excel

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

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

How To Recruit The Right Person For The Job

As a manager, one of your key responsibilities is finding competent, skilled staff that fit the role and the company well. They must be able to fulfil the skill set you need initially, with the potential to learn more and adjust easily to the style and atmosphere of the team and the working environment. How do you go about this?

» Article: Introduction to management course

I copy paste from Peoplesoft9 to a cell in Excel and the format on Excel changes to Currency $US

» Forum post: Copy paste from People soft

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you c...