This preview shows page 1. Sign up to view the full content.
Unformatted text preview: me IF followed by open parenthesis to define the alue_if_false] argument of the cond IF function. pe B2>14000 to define the gical_test argument of the third IF nction. pe “Spoil Risk” to define the alue_if_true] argument of the third IF nction. pe “OK” to define the alue_if_false] argument of the third function. Item Description Sugar Cocoa Beans Cocoa Butter Peanuts Almonds Starch Inventory Pounds 10000 7500 15000 8000 1200 12500 Status The Set up of t he Nest ed I F Fun I nv ent or y Dat a IF (B2<5000, “Prod Risk”, IF (B2<10000, “Low”, IF (B2>14000, • A new IF function is started in the [value_if_f argument for the purpose of conducting multiple • Both [value_if_true] and [value_if_false]
be used to add multiple logical tests. argu • The logical tests are in a sequence from lowe • It is important to note that a closing parenthes
for every IF function you started (Three closing each item. • Nested IF function displays one of four potent t ed I F Funct ion: Dat a ”, IF (B2>14000, “Spoil Risk”, “OK”))) he [value_if_false] ucting multiple logical tests....
View Full Document
- Spring '10