Fragen ID: 1552 19/19
PREVIOUS QUESTION

Insert the appropriate function in the cell Ε3 that returns the value TRUE if the content of
cell A3 is greater than 10 and the content of
cell B3 is greater than 10 and the content of
cell C3 is greater than 10 and the content of
cell D3 is TRUE.
Otherwise the function should return the value FALSE.

Reproduce that function up to the cell Ε50. Finally, insert a function in the cell Ε1 that returns the value TRUE if the value TRUE is displayed at least once in the cell range E3:E50. (use only the AND and OR functions)

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016