Assessment Library / Sample Questions / Q13
Item Q13
A spreadsheet contains the value 0.49 in cell B1. Cell B2 contains the formula below, which is then filled down to cell B37. =IF(B1<0.5, 1.92*B1, 1.92*(1-B1)) What value appears in cell B37? Give your answer to four decimal places.
Answer