Computer Science, asked by sahilsharma06322, 1 month ago

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1="NO"?
Select one:
a. The formula returns the text "NO. RESTART"
b. The formula returns the text "DONEN
C. The formula returns the text "NO".
d. The formula returns the text "RESTART"

Answers

Answered by shobhabidlan01

Answer:

The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel based on AND as well as OR logic. You will find a number of examples for different data types - numbers, dates, text, wildcard characters, non-blank cells and more.

Of all Excel functions, COUNTIFS and COUNTIF are probably most often mixed up because they look very much alike and both are purposed for counting cells based on the specified criteria.

Previous Question

Next Question

Similar questions

Math, 27 days ago

The value of tan 1o . tan 2o . tan 3o….tan 89o = ...

Geography, 27 days ago

(a)Study the climatic data of station X given below and answer the questions that follow: [3] Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Temperature (in C) 24.5 26.0 28.0 30.0 32.0 32.5 30.7 30.0 29.7 28.0 26.0 24.6 Rainfall (in cm) 2.8 0.7 0.7 1.5 4.5 5.1 9.5 11.3 12.4 28.1 34.5 13.6 (i)Calculate the annual range of temperature. (ii)Calculate the total annual rainfall...

English, 27 days ago

Long Answer Type Questions: Answer the following questions in not more than 60 words each : 1. Why was Lencho sad? What was his only hope? TAT 1TA1...

Math, 1 month ago

2) 'सुमा व दिलीप यांच्या वयांची बेरीज 50 आहे.' या माहितीचे गणिती भाषेतील रुपांतर खालीलपैकी कोणते? a) 2x + y = 50 b)2y+x = 50 c) x+y= 50 d) 2x+2y= 50 3) सौ. श्रेया यांनी 2018-19 मध्ये मिळवलेल्या उत्पन्नाचे करआकारणी वर्ष खालीलपैकी कोणते? a)2018-19 b)2017-18 c) 2016-17 d) 2019-20 4) 25 ते 35 ह्या वर्गाचा वर्गमध्ये कोणता? a) 25 Ab)30 c)27 d)29 B) खालील उपप्रश्न सोडवा. 4 1) 19, 19, 15, 20, 25, 15, 20,...

Geography, 1 month ago