Computer Science, asked by sahilsharma06322, 2 months 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

Psychology, 1 month ago

when a child goto an other side so how it feel...

Math, 1 month ago

8 - 25 Х 15 16 18 5 -X x 35 + ܗ | ܗ...

English, 1 month ago

At 6 o'clock Is a phrase or clause?

Math, 2 months 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, 2 months ago