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

if formula

ResolvedVersion 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:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.