SUMPRODUCT

0 Comments , in

previous NEXT SUMPRODUCT What Does It Do ?This function uses at least two columns of values. The values in the first column are multipled with the corresponding value in the...
Read More

SUMIF

0 Comments , in

previous NEXT sumif What Does It Do?This function adds the value of items which match criteria set by the user. Syntax=SUMIF(Range Of Things To Be Examined, CriteriaToBeMatched, RangeOfValuesToTotal) =SUMIF(C4:C12,”Brakes”,E4:E12) =SUMIF(E4:E12,”>=100″)...
Read More

SUM

0 Comments , in

previous NEXT SUM What Does It Do?This function creates a total from a list of numbers.It can be used either horizontally or vertically.The numbers can be in single cells, ranges...
Read More

RANDBETWEEN

0 Comments , in

previous NEXT RANDBETWEEN What Does It Do ?This function produces a random whole number between two specified numbers.The random number will change each time the spreadsheet is recalculated or F9...
Read More

RAND

0 Comments , in

previous NEXT RAND What Does It Do?This function creates a random number >=0 but <1. The number will change each time the worksheet recalculates, or when F9 is pressed. Syntax=RAND()...
Read More

ODD

0 Comments , in

previous NEXT ODD What Does It Do?This function rounds a number up to the next highest whole odd number. Syntax=ODD(NumberToBeRounded) FormattingNo special formatting is needed. Number Rounded To Next Odd...
Read More

MIN

0 Comments , in

previous NEXT MIN What Does It Do?This function picks the lowest value from a list of data. Syntax=MIN(Range1,Range2,Range3… through to Range30) FormattingNo special formatting is needed. Values Min 120 800...
Read More