Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 'if'' statements

	98.1 % recommend us
	More live stats...

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

Training information:

'if'' statements

Resolved · Low Priority · Version 2003

Reply Fri 19 Nov 2010, 15:49Delegate Rebecca said...

Rebecca has attended:
Excel Intermediate course

'if'' statements

Please re-iterate the structure of if statements

For upcoming training course dates see: Pricing & availability

Reply Mon 29 Nov 2010, 09:39Trainer Simon said...

RE: 'if'' statements

Hi Rebecca,

Thank you for your question.

An IF statement consists of three arguments, Condition or Logical Test followed by a True answer and a False answer.

Here is an example:

=IF(C2>200,"Yes","No")

OR

=IF(C2>200,A2*5%,A2*2.5%)

So Logical Test, True, False.

I hope this answers your question.

Regards

Simon

Sun 5 Dec 2010: Automatically marked as resolved.

Excel articles

· Easing the Transition to Excel 2007
· The Mysteries Of Excel Explained
· How to start using Excel 2007 Functions
· Do You Need To Run Excel 2007 In Compatibility Mode?
· Coping With Compatibility In Excel 2007

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

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips