Question ID: 5398 15/36
PREVIOUS QUESTION NEXT QUESTION

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

 

 

Other versions
OpenOffice.org Calc 3.3LibreOffice Calc 4.0

 

 

 


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