November 22, 2010

The ‘If Statement’ is often used for basic reporting in Excel. It provides an easy method of assessing the truth of an  assertion and then returning one of two values depending on whether the assertion is true or false.

Syntax: IF(logical_test, [value_if_true], [value_if_false])

In this example an ‘If Statement’ tests whether the value ‘MyDate’ is larger or equal to the date above the target cell; the result is either an actual or a budget value depending on the truth of the assertion:


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: