if formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If formula

If formula

resolvedResolved · Low Priority · Version 2007

Sandra has attended:
Excel Introduction course

If formula

What is the purpose of IF and would it be the bet formula for predicting profit on sales?

RE: If formula

Hello Sandra,

The If statement allows for Logical to be applied to your excel formulas. It takes the form of:
If something equals five hundred then do this, otherwise do that!

It could not predict profit on sales as you ask.

The If statement is written like this:
If(Question , True, False)

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Fri 1 Jun 2012: Automatically marked as resolved.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.09 secs.