Question: What will happen if , in an IF function, you accidentally omit the quotes from the value _ if _ true and value _ if

What will happen if, in an IF function, you accidentally omit the quotes from the value_if_true and value_if_false arguments as follows?
=IF(C4, eligible, ineligible)
Excel will default to putting in zero (0) for the if_value_true argument and zero (0) for the if_value_false argument when the condition is met
Excel will automatically put quotes around these for you and the function will execute without error
Excel will look for a range named eligible or ineligible (depending on which condition was met) and either returns the value from that range or gives a #NAME? error if the named range does not exist
Excel will not allow you to complete the function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!