2009/3/11 Chris Bia <[email protected]> > Hello Harold Fuchs ! I'm following your method, but when i arrive to point > 5), the result on Column C is this: > #NAME? > #NAME? > #NAME? > #NAME? > #NAME? > #NAME? > > ... > > For every cells ;-/
It looks to me as if you copied my formula exactly. the "A1" and "B1" in my formula are *examples* based on my procedure which has the addresses in Column A and you copied them into column B. If instead you used columns Q and X then the formula would be "=IF(Q1="";X1;"")". Hmmm. On reflection I don't think that can be the answer because your sheet almost certainly has A1 and B1. Hmmmm. Perhaps you are not entering the formula correctly. The outer quotes must *not* be entered. Apart from that I suggest you copy my formula and paste it into the first cell of your column C and then change the A and B as necessary. Oh. Are you using OxygenOffice? There has been some discussion that in OxygenOffice the semicolons between the parts of a Calc function should be replaced by commas. So the formula would be "=IF(A1="",B1,"")". If this still doesn't work, send a sample as an attachment to your next message. I think this list allows Calc documents as attachments. <snip> -- Harold Fuchs London, England Please reply *only* to [email protected]
