April 29, 2012
by lsonlyat
0 comments
The Mid formula can come in handy as the Mid fomrula will extract certain text from a cell. If you had a text string or a cell with > 000_CAM01_001, with the Mid formula you can obtain just the CAM01 part of the string or cell without modifying it manually. Continue reading
April 29, 2012
by lsonlyat
0 comments
The average formula is another formula that is used quite a bit in Excel because it is used to find the average of any given numbers, it is the same in Excel. The average is the middle number between two numbers, if you had to find the average of 1 and 1, the result would… Continue reading
April 19, 2012
by lsonlyat
0 comments
The Iferror formula is a logical function but it will also tell the use if there is an error with a cell or a formula used. The iferror formula must have a calculation to perform in order for it to work. Quick example, If you used = iferror ( 10/2,”error”). you would get a result… Continue reading
April 18, 2012
by lsonlyat
0 comments
The concatenate formula is used to combine several cells with text or text strings. The concatenate formula can be used to combine up to 255 cells or text strings into one. This means you can add cell A1, A2,…,A255 to make one text string. Continue reading
April 4, 2012
by lsonlyat
0 comments
The networkdays formula will calculate the total net working days between two periods. The networkdays formula will only give you the net work days, no weekends included. This formula can be different if you want to include some holidays. Continue reading
March 26, 2012
by lsonlyat
0 comments
In Excel you can create a power formula. To break it down for you, A power formula is basically a number times itself or multiple times. Example, 8 to the power of 4 would give you; 8 * 8 * 8 * 8 = 4096. This formula is more for scientific purposes but some financial… Continue reading
March 12, 2012
by lsonlyat
0 comments
The Lower formula is the opposite of the Upper formula. The Lower formula will transform the selected cell text to lower case. Quick example is lets say you have the text > MY NAME, and you used the lower formula, the text will become > my name.
Formula
= Lower ( cell… Continue reading