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