cell I2 : =IF(H2="J";E2;'') result in cell I2 --> error #VERW! (in Dutch; in English(?): #REF! when the formula is changed into =IF(H2>1;E2;'') the cell E2 is correctly copied in cell what is wrong with the textual equation(first line above)
If that is really '' in the else expression it should be a #NAME? error instead, an empty string is to be written as "" not ''. For the second case it should be the same error though. Please be specific what exactly you are doing. Or maybe attach a sample document. I actually doubt this is a bug, looks more like a usage error.
hello Eike yes user error, so sorry, I used single quotes in the if H2='J' ; changed to if H2="J" and it is ok thanks for your answer and pardon me for the confusion: I thought single qoute would be compatible with " met vriendelijke groet Ruud van der Made Informade 0620744762 Op 13-5-2013 20:08, bugzilla-daemon@freedesktop.org schreef: > > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=64557#c1> > on bug 64557 <https://bugs.freedesktop.org/show_bug.cgi?id=64557> from > Eike Rathke <mailto:erack@redhat.com> * > If that is really '' in the else expression it should be a #NAME? error > instead, an empty string is to be written as "" not ''. For the second case it > should be the same error though. Please be specific what exactly you are doing. > Or maybe attach a sample document. I actually doubt this is a bug, looks more > like a usage error. > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. >
Marked as RESOLVED INVALID - user error per comment 2.