1

2

3

Complete the following statement regarding nested IF functions. When creating a nested IF function, the argument is defined with a second IF function. Complete the following statement with regards to the IF function. When defining the [value-if-true] or [value_if_false] arguments of the IF function, words must be enclosed in otherwise the output of the function will be the NAME error code. The value in cell E10 on an Excel worksheet contains the amount of profits earned from an investment. A nested IF function will be entered into cell F10 to evaluate the value in cell E10. If the value in cell E10 is less than zero, the output of the function should be the word HOLD. If the value in cell E10 is greater than or equal to zero but less than 100, the output of the function should be the word SELL. Any value greater than or equal to 100 , the output of the function should be the word BUY. Which of the following nested IF functions will produce an accurate output based on the information provided? =IF(E10100,"BUY",IF(E10=100,"BUY",IF(E10=100,"BUY",=IF(E10