What is Zoster Vaccine Live (Shingles Vaccine), and how does it work (mechanism of action)? Zoster vaccine contains live, attenuated (weakened) varicella-zoster virus (VZV). Varicella-zoster causes chickenpox and then becomes dormant in nerves.
To make the 2013 exam more helpful, we've replaced individual tasks with comprehensive, project-based testing. This live-in-the-application environment confirms that certified individuals have demonstrated the ability to complete a realistic Microsoft Office Specialist Excel 2013 project.
Answer: In cell C1, you can use the following Excel formula with 3 nested IF functions: =IF(B1=0,A1/2, IF(B1=1,(A1/2)*0.2, IF(D1=1,(A1/2)-5,))) Please note that if none of the conditions are met, the Excel formula will return  as the result.