| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 116956 | 2011-03-27 09:59:00 | Openoffice Calc | Phil B (648) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1189790 | 2011-03-27 09:59:00 | Is there a way to turn off the error checking when creating formulas? I get the result I want, but it returns errors that you can't get rid of. Example =IF(OR(Q20=R20);"";"");IF((E20)<(F20);1;0.5) It returns error 509, operator missing. |
Phil B (648) | ||
| 1189791 | 2011-03-27 20:06:00 | So fix the error. | pctek (84) | ||
| 1189792 | 2011-03-27 20:07:00 | That's what I get when I tried your formula. What result are you getting that you wanted - I always see "Err:509"? You seem to have 2 separate & complete IF() statements separated by a semicolon; I'm not surprised you're getting an error. Are you sure your formula does what you want it to do in all cases? What are you trying to do? |
MushHead (10626) | ||
| 1189793 | 2011-03-27 21:43:00 | You also appear to have a redundant OR Actually, that entire first IF is redundant. |
fred_fish (15241) | ||
| 1189794 | 2011-03-27 21:46:00 | I put this question on the openoffice forum & got the answer I was looking for. I explained myself better there too, sorry. www.oooforum.org |
Phil B (648) | ||
| 1 | |||||