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

'if'' statements

ResolvedVersion 2003

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

Rebecca has attended:
Excel Intermediate course

'if'' statements

Please re-iterate the structure of if statements

Mon 29 Nov 2010, 09:39 Trainer 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

'if'' statements

'if'' statements

RE: 'if'' statements

Excel articles

Excel tip:

Select only cell that contain text to lock format