Which of the following functions does not contain a logic error?
A)=IF(00,"yes"."no")
B)=IF(B5B5,"yes","no")
C)=IF(B6/0C6/0,"yes","no")
D)=IF(B6C6,"Yes","No")

Question

Which of the following functions does not contain a logic error?
A)=IF(0>0,"yes"."no")
B)=IF(B5>B5,"yes","no")
C)=IF(B6/0>C6/0,"yes","no")
D)=IF(B6>C6,"Yes","No")

Quizplus · Accepted Answer

Option D does not contain any logical error as it checks if the value in cell B6 is greater than the value in cell C6 and returns "Yes" if true, and "No" if false. On the other hand, options A, B, and C contain logical errors that can lead to unexpected results. Option A uses ">" instead of ">=" and will always return "no" as 0 is not greater than 0. Option B uses the same comparison operator for the same cell, which doesn't make sense. Option C includes division by zero, which will result in an error.

Which of the Following Functions Does Not Contain a Logic