BUSN INFO SYSTEM CONCEPT
BUSN INFO SYSTEM CONCEPT INFO 209
Popular in Course
Popular in Information & Operations Mgmt
This 1 page Class Notes was uploaded by Darwin Stamm on Wednesday October 21, 2015. The Class Notes belongs to INFO 209 at Texas A&M University taught by Paul Ammons in Fall. Since its upload, it has received 20 views. For similar materials see /class/226260/info-209-texas-a-m-university in Information & Operations Mgmt at Texas A&M University.
Reviews for BUSN INFO SYSTEM CONCEPT
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/21/15
1 L icalite 1 it no hie entered 0 IF quot I 1 greater than F returnquot one value if a condition I UE and another v lue if FALSE F l l e Returns a value from a cell or set of values through association by top of row value HLOOKUP lookup value tableiarray rowiindexinum rangeilooku L v 7 value in 1 row of table T a 7 table of info for lookup to reference Description Riiin 7 row in Tia from which yalue will be returned if lt1 VALUEl ifigtroyvs REF R717 T or F If T exact or closest is supplied IfF only exact or else NA is given Ass39gns a latter grade F IfHLOOKUP cant find L v andR l is T largest value still less than Liv is used IfL v is ltsmallest value in 1quot row of Tia retums NA If R71 is F and Liv is text you can use characters in Liv c 9a c 7 match an 39 1 find or user4 on I muhwna IiA4gt5939 unction row row row C43TRUE row 3 that39s in the same column Because B is not an exact match the next largest value that is a n aw a V mm H m min r i a tax