COMM 205 Study Guide - Midterm Guide: Lookup Table, Stata, Umber
Document Summary
Cell reference: if dragged: a(cid:271)solute (cid:272)ell (cid:396)efe(cid:396)e(cid:374)(cid:272)e , (cid:449)o(cid:374)"t e(cid:448)e(cid:396) (cid:272)ha(cid:374)ge. Evaluates if all logical arguments inside are true =or(logical1, [logi(cid:272)al(cid:1006)], (cid:895). Evaluates if at least one of arguments are true, - can use both in conjuctions with if, example: =if(or(b3=sunny,b3=mixed),sunglasses,none) both up to 255 logical conditions. Counts values in a specific range that meets certain criterias, up to 127 criterias - (cid:272)a(cid:374)"t use fo(cid:396)(cid:373)ula i(cid:374) (cid:272)(cid:396)ite(cid:396)ia_(cid:396)a(cid:374)ge, -ex. Adds values in a specified range or multiple ranges that meet specific criteria, at least 1 criteria up to 127, sum_range must be same size and shape as criteria_range. !sumifs and contifs both need (cid:395)uotatio(cid:374) (cid:373)a(cid:396)ks (cid:862) (cid:862) to e(cid:374)(cid:272)lose (cid:272)o(cid:374)st(cid:396)ai(cid:374)ts. The vlookup function looks up a value in the first column of a range of cells, and then returns a value from any cell on the same row of the range. 0 f 50 d 90 a+, 90 is. Breakpoint, no need to write 100 in range.
