Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help! I will give thumbs up and review!! (Part 9 of 11) 3 ULOQKUP Esact match - Find corresponding information in a list of
Please help! I will give thumbs up and review!! (Part 9 of 11)
3 ULOQKUP Esact match - Find corresponding information in a list of data Hoy To: See the Sec 2-VLDOKUP tab Task lnstructions: See the Sec 2-VLDDKUP tab 4 IF - Tell Excel to perform different calculations depending on whether the answer to your question is true or false. Hov To: If the value in cell A1 is greater than the value in cell B1, then multiply the value in A1by 5 . If not, multiply the value in B1by 2 . Formula: =|F(A1>B1,A1"5, B1"2) Dperators you can use: = Equal to > Greater Than >= Greater than or equal to \langle angle Less than or greater than Task Instructions: Create the following IF formula: if cell B50 is less than or equal to cell C50 then multiply cell C50 by 2. If not, multiply oell B50 by 3. 32 5 SUMIF - Estends the capabilities of the basic SUM function by allowing you to tell Excel to only SUM items that meet a certain criteria. Hov To: Type =SUMIF( then select the range that you want Eycel to find a certain criteria in, CDMMA, then type in the criteria you want Excel to look for lif using an alphabetized criteria then put it in quotations - for example a "Specific Name"], COMMA, then select the range you want Encel to sum from, and then close the parenthesisStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started