Fragen ID: 1217 1/15
NEXT QUESTION

Enter the appropriate function in the cell B1, so that if the value in the cell (A1) is higher than 5000, the function will return 1. If the value in the cell A1 is less than or equal to 5000, the function will return 0. Reproduce the function up to the cell B10.

 

 

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

 

 

 


Enter the appropriate function in the cell B1, so that if the value in the cell (A1) is higher than 5000, the function will return 1. If the value in the cell A1 is less than or equal to 5000, the function will return 0. Reproduce the function up to the cell B10.