Question: this is a question about excel vba Here is an Excel worksheet. 1 Animals 2 Cats 3 Dogs Adjectives Cool! Awesome! 5 What do we

this is a question about excel vba Here is an Excel

this is a question about excel vba

Here is an Excel worksheet. 1 Animals 2 Cats 3 Dogs Adjectives Cool! Awesome! 5 What do we have? 6 Cat 8 What do we know about it? 9 Cool! An Excel formula is put in cell A9. The formula will show Cool! if Cat is put in cell A6, show Awesome! if Dog is put in cell A6, and show whatever... if anything else is put in cell A6. Which one of the following is the Excel formula in cell Ag? =IF (LEFT(A6,3)=A2,B2, IF(LEFT(A6,3)=A3,B3, "whatever...")) =IF(NOT (AND (A6=LEFT(A2,3), A6=LEFT(A3,3))), "whatever...", IF(A6=LEFT(A2,3), B2, B3)) =IF (NOT (OR (A6=LEFT (A2,3), A6=LEFT(A3,3))), "whatever...", IF(A6=LEFT(A2,3), B2,B3)) =IF(A6=A2,B2,IF(A6=A3, B3, "whatever..."))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Can someone explain this in detailed step by step using excel? The file named e10m2Animals_LastFirst.xml contains - - Cat 3 years Male Paws White 3/15/2018 - Cat 8 years Female Mama Mia Calico...

EX16_XL_CH10_GRADER_ML2_HW - Animal Shelter 1.5 Project Description: You manage a small animal shelter in Dayton, Ohio. Your assistant created an XML document that lists some of the recent small...

vba.skilling.us Avoiding bugs Programming with Excel VBA Please Look At The Calo - VBAProject (FUNCRES.XLAM) 29 Solver (Solver.xlam) VBAProject (taxes-bad-formatting.xl... Yucky code Exercise...

Peter loves dogs and cats. For the past several years, he has owned and operated Homeward Bound, which temporarily houses pets while their owners go on vacation. For the month of June, the company...

EX16_XL_CH10_GRADER_ML2_HW - Animal Shelter 1.2 Project Description: You manage a small animal shelter in Dayton, Ohio. Your assistant created an XML document that lists some of the recent small...

please help 1. 2. The cash records and bank statement for the month of July for Hawk Incorporated are shown below. Description DEP Customer deposit INT Interest earned SF Service fees NOTE Note...

Need help with some corrections... but need it by tonight. (should be simple corrections but still need help. Pet Palace Dog Den Cat Castle Direct Material Price Variance Direct Material Price...

the Excel Solver. In Assignments 2 to 6 inclusive, you will be asked only to use either LINGO or the Excel Solver. Based on your experience with Assignment 1, Question 5, do whichever you find...

Each question in Assignment 2 is worth 20 marks. For each question, do the following: (a) Formulate a model for the problem either in LINGO syntax or an Excel file. 1 For each model: (i) Write your...

[PYTHON PROGRAMMING] { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Preamble: A Brand new Jay ", " ", "After an eventful season on season 8 of *A Brand New Jay*, the 3...

Case Study: ‘Sydney Gifts’ ‘Sydney Gifts’ run a store selling good quality antiques and have been in operation for twenty years. They currently maintain details of every piece...

Discuss the status of woman in medieval age in detail.

3 . SMC is considering an investment that is projected to produce operating profits of P 2 2 5 , 0 0 0 before depreciation for the next four years. At the beginning of the first year ( 2 0 2 1 ) ,...

Jett Company produces and sells three products. Information about these products for the most recent year is provided below: Product H Product A Product T selling price per unit $ 3 5 $ 4 6 $ 2 2...

1. Management Quick Views: Management Quick Views provide practical information on more than 40 common management topics related to business, leadership/management competencies, productivity, and HR...

4. Development road map: Descriptions of development activities that should occur at each career level and that support development needs and prevent derailers. These activities include job...

3. Development needs: Needs that frequently occur at each career level, those that vary by individual, and the derailers that can stall career progress and negatively affect performance. Ways to...