Question: hat will happen if , in an IF function, you accidentally omit the quotes from the value _ if _ true and value _ if
hat will happen if in an IF function, you accidentally omit the quotes from the valueiftrue and valueiffalse arguments as follows?
IFC eligible, ineligible
Group of answer choices
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
Excel will automatically put quotes around these for you and the function will execute without error
Excel will default to putting in zero for the ifvaluetrue argument and zero for the ifvaluefalse argument when the condition is met
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
