what im trying ti do is to make the formula to show an error message when
(A2 and B2) both cells have been entered with data at the same time. that is
to say i want the results to be generated from either A2 or B2, not both.
when both cells (A2 and B2) are entered with data it should show "ERROR".
this is the best way i could explain. please help.