I have created a formulae that asks if A1 = B1 then return the number 3 and
if not do nothing (for example =IF(A1=B1,3,"") and it works fine as long as
there are numbers there. My problem is that i want to set up a table and
this equasion has been draged down the page but when the cells are blank it
returns a 3 (because both cells are the same) and i only want it to show when
a number has been inserted to the relavant cells.
Please help it's driving me nuts.