Friday, March 28, 2014

true/false match formula

Theory:
To test if the values of 2 adjacent cells match exactly do the following:
=cell1=cell2
The results will be displayed as "True" if the pairs match or "False" if the pairs don't match.
Example:
You want to compare cell A2 to cell B2.  Let's say both cells have the value of 108.  The formula would be:
=A2=B2
The result would be "True".

Read More..

Sunday, March 9, 2014

Date Formula

FormulaDescriptionValue
=NOW()Returns today's date and time24/06/2012 20:15
=TODAY()returns today's date24/06/2012
=WEEKDAY(NOW())Returns the day of the week for today (Sunday) as a number1
=WEEKDAY(TODAY())Returns the day of the week for today (Sunday) as a number1
=DAY(TODAY())Retruns the day of the month for today (24th)24
=DAY(NOW())Retruns the day of the month for today (24th)24
=WEEKNUM(NOW())Returns the week number of the year which is 26 weeks into the year for today26
=WEEKNUM(TODAY())Returns the week number of the year which is 26 weeks into the year for today26
=MONTH(NOW())Retruns the month of the year which is 6 (June)6
=MONTH(TODAY())Retruns the month of the year which is 6 (June)6
=YEAR(NOW())Retruns the current year which is 20142014
=YEAR(TODAY()Retruns the current year which is 20142014
Read More..

Straight Line Value Formula

Excel Straight Line (SLN) Depreciation YouTube Video

The straight line value is an excel formula which calculates the total depreciation amount of an asset you may hold for you business. Such as manufacturing machines.

Theory:

=SLN(Cost of item, Lowest depreciated value, Life span of asset in years)

Example with number values:

=SLN(6789,1000,10)

Example using cell references:

=SLN(A2,A3,A4)

Where cells:

A2 = Cost of item

A3 = Lowest depreciated value

A4 = Life span of asset in years
Read More..

Friday, January 3, 2014

Growth Formula

The Growth formula is used to forecast predicted growth in for example a business's projected sales figures.
Theory:
=Growth(previous sales data range, previous month numbers data range, new month number or cell reference)
Example:
=Growth($B$2:$B$13,$A$2:$A$12,C2)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last cell reference being "C2" in this case. Then fill the formula down.
OR
=Growth($B$2:$B$13,$A$2:$A$12,13)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last part which is just a number in this case "13". This paticular formula using the number 13 and not a cell reference is only useful for single next month prediction.
Read More..

Tuesday, December 31, 2013

Trend Formula

The Trend formula is used to forecast predicted growth or decline in most popularly sales figures of a business.
Theory:
=Trend(previous sales data range, previous months data range, new month number or cell reference)
Example:
=Trend($B$2:$B$13,$A$2:$A$12,C2)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last cell reference being "C2" in this case. Then fill the formula down.
OR
=Trend($B$2:$B$13,$A$2:$A$12,13)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last part which is just a number in this case "13". This paticular formula using the number 13 and not a cell reference is only useful for single next month prediction.
The table below is a sample data set. NB: T is for Trend Forecast and mn is for Month.
A       B          C        D
mn  sales    T.mn   T.sales
1      8685    13       5625
2      7865    14       5437
3      9765    15       5248
4      4455    16       5060
5      7865    17       4871
6      2334    18       4683
7      9876    19       4494
8      5647    20       4306
9      7864    21       4117
10    3456    22       3929
11    9823    23       3740
12    4567    24       3552
Read More..

Thursday, December 26, 2013

Math Operators


= Equals
< Less Than
> Greater Than
<= Less Than OR Equal To
>= Greater Than OR Equal To
<> Not Equal To OR !=
* Wildcard
? Single Character Wildcard

Read More..

Sunday, October 27, 2013

FORECAST Formula

Theory:
=FORECAST(Month Number to predict, Range of sales for prior 12 months, Range of month numbers for the year from 1 to 12)
Sales Table:
          A           B
1     Month   Sales
2     1            2457
3     2            8544
4     3            4145
5     4            6425
6     5            7885
7     6            8643
8     7            2354
9     8            4235
10   9            8664
11   10          4627
12   11          9753
13   12          9999
Example:
=FORECAST(8,B2:B13,A2:A13)
You should open a new excel workbook and populate  cells A1 to B13 with the headers and data listed above. Then in a separate cell enter the formula above to see your prediction for the month of August (8).
Read More..

www.cineclouds.com. Powered by Blogger.