If working strangely

robbyn · OOo Advocate Joined: 29 Mar 2004 Posts: 308

I am amalgamating two columns of figs. F2 is Dr, G2 is Cr.

IF(F2>0:F2:-G2) does not work on this particular list of values, event though F2 is blank it still returns a blank instead of -G2. I also tried F2>1000 if still returned the value of F2 even though it is blank. I reinstalled calc. It made no difference.

I had to use the following instead:
IF(ISNUMBER(F2);F2;-G2)

Does any one recognise what is going wrong?
_________________
Robin

When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.

David · Posted: Sat Mar 29, 2008 2:38 pm Post subject:

Aside from the fact that your upper formula has colons instead of semicolons, I just now tried it [with semicolons], and it works fine in version 2.3.

David.

robbyn · OOo Advocate Joined: 29 Mar 2004 Posts: 308

I have used that formula many times and it has worked with the correct semi colons. What I am finding is in this particular instance it is not working and I can not see why? How do you suggest I find what is fooling the IF into assuming that a cell showing no content has a value >1000?
_________________
Robin

When you love a delicate rose remember she has thorns and a root. In time the petals will fall away.

David · Posted: Sat Mar 29, 2008 7:03 pm Post subject:

Then I do not understand why here you used colons except for a typo? In any event, I can not see a reason for failure since, as I said, it [ =IF(F2>0;F2;-G2) ] works for me in either case.

David.

Villeroy · Posted: Sun Mar 30, 2008 5:56 am Post subject:

There might be text in F2. =ISTEXT(F2) ?
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

jrkrideau · Posted: Tue Apr 01, 2008 8:28 am Post subject: