Question ID: 1552 19/19
PREVIOUS QUESTION

Insert the appropriate function in the cell E3 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 E50. Finally, insert a function in the cell E1 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 2016Microsoft Excel 365

 

 

 


Insert the appropriate function in the cell E3 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 E50. Finally, insert a function in the cell E1 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)