Argu the logical tests are in a sequence from lowe it

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online