August 11, 2010

When including complex formulae in your report design, it is often prudent to provide notes to those formulae when trying to decifer them at a later time or for the sake of other users of the spreadsheet.

To do this you may make use of the ‘N’ function which  converts a text string to the number zero. In this way you can add the result of your ‘N’ function to the rest of your formula without affecting the desired formula result.


 = sumif (RngPer,  A$1,  Rng_Km) /countif(RngPer, A$1) + N(” Returns the avg mileage per period for each active truck”)

Craig Juta, Excel Trainer, Western Canada


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: