From users-return-4648-apmail-openoffice-users-archive=openoffice.apache.org@openoffice.apache.org Mon Jun 3 10:13:31 2013 Return-Path: X-Original-To: apmail-openoffice-users-archive@www.apache.org Delivered-To: apmail-openoffice-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id ACBE4C204 for ; Mon, 3 Jun 2013 10:13:31 +0000 (UTC) Received: (qmail 39786 invoked by uid 500); 3 Jun 2013 10:13:31 -0000 Delivered-To: apmail-openoffice-users-archive@openoffice.apache.org Received: (qmail 39592 invoked by uid 500); 3 Jun 2013 10:13:30 -0000 Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openoffice.apache.org Delivered-To: mailing list users@openoffice.apache.org Received: (qmail 39580 invoked by uid 99); 3 Jun 2013 10:13:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Jun 2013 10:13:30 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_IMAGE_ONLY_32,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [212.51.32.151] (HELO smtp4.mundo-r.com) (212.51.32.151) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Jun 2013 10:13:24 +0000 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Ah0JABtrrFFbdfwq/2dsb2JhbABZgkUKaoM8tyyEFwQBgRR0ghsPBR4LGwUIDi4CHQEBAQkZAgQVAQ4LCB4OBwMBAQUDFASFVYIXBI4ajEOOeZE+jXUVaQoPIhaCLg6BBgOQAIEthhGRQIMRbIEDNg X-IPAS-Result: Ah0JABtrrFFbdfwq/2dsb2JhbABZgkUKaoM8tyyEFwQBgRR0ghsPBR4LGwUIDi4CHQEBAQkZAgQVAQ4LCB4OBwMBAQUDFASFVYIXBI4ajEOOeZE+jXUVaQoPIhaCLg6BBgOQAIEthhGRQIMRbIEDNg X-IronPort-AV: E=Sophos;i="4.87,791,1363129200"; d="gif'147?scan'147,208,217,147";a="47943608" Received: from 42.252.117.91.static.mundo-r.com (HELO zimbra.ayto.vigo) ([91.117.252.42]) by smtp4.mundo-r.com with ESMTP; 03 Jun 2013 12:13:01 +0200 Received: from localhost (localhost [127.0.0.1]) by zimbra.ayto.vigo (Postfix) with ESMTP id DB7C6A2468 for ; Mon, 3 Jun 2013 12:13:01 +0200 (CEST) X-Virus-Scanned: amavisd-new at vigo.org Received: from zimbra.ayto.vigo ([127.0.0.1]) by localhost (zimbra.ayto.vigo [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id L6ikDMSAa0ig for ; Mon, 3 Jun 2013 12:13:01 +0200 (CEST) Received: from zimbra.ayto.vigo (vigo.org [172.28.20.37]) by zimbra.ayto.vigo (Postfix) with ESMTP id 8EFC5A2463 for ; Mon, 3 Jun 2013 12:13:01 +0200 (CEST) Date: Mon, 3 Jun 2013 12:13:01 +0200 (CEST) From: Luis Iglesias To: users@openoffice.apache.org Message-ID: <1129815351.396163.1370254381453.JavaMail.root@zimbra.ayto.vigo> In-Reply-To: <51AC5F6B.5010508@neterra.net> Subject: Re: Problem with a formula MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_396161_362836402.1370254381447" X-Originating-IP: [128.193.40.102] X-Mailer: Zimbra 6.0.8_GA_2661 (ZimbraWebClient - FF3.0 (Linux)/6.0.8_GA_2661) X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_396161_362836402.1370254381447 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi.=20 The problem is not with fractions but with the values you expect in your co= nditional. Your formula only applies when A23 < B9 or when A23 =3D (1,2,3,4= ,5,6,7,8). You can fix in your last IF:=20 ...IF(A23=3D8;$F$16;1 )...=20 or maybe you're looking for something like :=20 =3DIF(A23<$B$9;$F$8;IF(A23>8;$F$16;IF(A23>7;$F$15;IF(A23>6;$F$14;IF(A23>5;$= F$13;IF(A23>4;$F$12;IF(A23>3;$F$11;IF(A23>2;$F$10;IF(A23>1;$F$9;1)))))))))*= A23*D23=20 ----- Mensaje original ----- De: "=D0=AF=D0=B2=D0=BE=D1=80 =D0=9C=D0=B0=D1=80=D0=B8=D0=BD=D0=BE=D0=B2" <= ymarinov@neterra.net>=20 Para: users@openoffice.apache.org=20 Enviados: Lunes, 3 de Junio 2013 11:18:35=20 Asunto: Problem with a formula=20 Hello,=20 I'm having a problem with a formula that i have=20 =3DIF(A23<$B$9;$F$8;IF(A23=3D1;$F$9;IF(A23=3D2;$F$10;IF(A23=3D3;$F$11;IF(A2= 3=3D4;$F$12;IF(A23=3D5;$F$13;IF(A23=3D6;$F$14;IF(A23=3D7;$F$15;IF(A23=3D8;$= F$16)))))))))*A23*D23=20 If the content of A23 is integer the formula works fine, but if the=20 content of A23 is =D0=B0 fraction the result is 0.=20 Can anyone point where can be the mistake?=20 ---------------------------------------------------------------------=20 To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org=20 For additional commands, e-mail: users-help@openoffice.apache.org=20 --=20 Luis Iglesias Rejas=20 Servizo de Administraci=C3=B3n Electr=C3=B3nica=20 Praza do Rei, 1 - Planta 7=C2=AA=20 36202 VIGO=20 Tfno: 986 810 159 / Fax: 986 220 341=20 Web: www.vigo.org=20 ------=_Part_396161_362836402.1370254381447 Content-Type: multipart/related; boundary="----=_Part_396162_1485334581.1370254381447" ------=_Part_396162_1485334581.1370254381447 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: Verdana; font-size: 10pt; color: #000000'>Hi.
= The problem is not with fractions but with the values you expect in your co= nditional. Your formula only applies when A23 < B9 or when A23 =3D (1,2,= 3,4,5,6,7,8). You can fix in your last IF:
...IF(A23=3D8;$F$16;1)...
= or maybe you're looking for something like:
=3DIF(A23<$B$9;$F$8;IF(A2= 3>8;$F$16;IF(A23>7;$F$15;IF(A23>6;$F$14;IF(A23>5;$F$13;IF(A23&g= t;4;$F$12;IF(A23>3;$F$11;IF(A23>2;$F$10;IF(A23>1;$F$9;1)))))))))*A= 23*D23



De: "=D0=AF=D0=B2=D0=BE=D1=80 =D0= =9C=D0=B0=D1=80=D0=B8=D0=BD=D0=BE=D0=B2" <ymarinov@neterra.net>
Para: users@openoffice.apache.org
Enviados: Lunes, 3 de Juni= o 2013 11:18:35
Asunto: Problem with a formula

Hello,
<= br>I'm having a problem with a formula that i have

=3DIF(A23<$B$9= ;$F$8;IF(A23=3D1;$F$9;IF(A23=3D2;$F$10;IF(A23=3D3;$F$11;IF(A23=3D4;$F$12;IF= (A23=3D5;$F$13;IF(A23=3D6;$F$14;IF(A23=3D7;$F$15;IF(A23=3D8;$F$16)))))))))*= A23*D23

If the content of A23 is integer the formula works fine, but= if the
content of A23 is =D0=B0 fraction the result is 0.

Can a= nyone point where can be the mistake?


--------------------------= -------------------------------------------
To unsubscribe, e-mail: user= s-unsubscribe@openoffice.apache.org
For additional commands, e-mail: use= rs-help@openoffice.apache.org



--
= <= span style=3D"color: rgb(115, 115, 115);">Luis Iglesias Re= jas
Servizo de Administraci=C3=B3n Electr=C3=B3nica
Praza do Rei, 1 - Planta 7=C2=AA
= 36202 VIGO
Tfno: 986 810 159 / Fax: 986 220 341
<= br>Web: www.vigo.org
=


------=_Part_396162_1485334581.1370254381447 Content-Type: image/gif; name=logo_concello.gif Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=logo_concello.gif Content-ID: R0lGODlh5gBPAPU/AAEBARYWFi4uLjUpBw45dk8yCnBRC3FjJWlZG1BRUG9vb2hyUR9IeCVXi0Jk inKKanCcnnC5y3zJ2nzN43vR6ZNyBal2BZNcFZlnYdUuM+stN+onL9seKe05RNI4Qu5CS+1MVPBG T9VYYLM6HvJ9hNN+g4Z5g6+KBp6LH42XYMyUA+ikANimBcyBfI+Pj6ioqLS0tKSutI6lqJDH1fGM kvi0tuWusNueofm8wNjZ2MfJyubm5v7+/uvz89De4Z69ziH5BAAAAAAALAAAAADmAE8AAAb+QNon FAIRjSCksXgcLpPJY1EpLTqPUGk0yrR2oc+p+Hudcqnn5jfL3Ia9Tzaow+3QePg8D9f5+IdEIR10 g3OERIWJS4iLXYGAgUR+kU0kNT14mD2bnDybnjuZmKGhPDuanKigoqatpqidnz2ln6R4p56puau7 tq+5sZq0o664qaqzrL7GoZg1NJh6PDUbGtbW1dcd1tsb3dsa2+DZGuTY1eYbGdjX1uvl2CQ40vT1 9vf4+fr7/P3+//qeRdNDrZ1BbQY7mEt4sGE7cA7bWQJIsaLFixgz2ntWr2BEdh9DihxpbaLGkyhT qqQokJ5Hkg8XwpzJTQONGitz6typkqP+Sw40gwp1KGIez6NIkwa841Lm0IMKZ0aNSMOo0qtYkbaU 9vKp15lVs4od2xNa05neIHo7OOIdyJEQD8ojS7duRZ9cnX7ckA5bhwweLLgN99VaWLuIE+PbSlBv xKne+EL0UAGDQcleReBUzLnzNLNcgcIF2a2ah9MZUqBIAfgD4HKORx72TLsu3sZCyZnAAAGD7wcP UiwwkUKBbw9xg86uzTzr7TxdEUaMjEFGbwwXfC+A8MA3htUQIIjIbLW5+aSMocduyFediQgVRpzj fSFDew8oemdIDnP5+f86PYdHdCJ5YIIJEEyAwmAbXACBBeR0MEIKM+yGgWgzzQXghjn+pTfgegZ5 wN0FKUBwgjVAbcBBChIsSM4GFkCgwAEPSADUYCFpuM8OLiiwgAIvDERPDy8okACQQuZB5Asw5EDP DkzCUIo0PcDgowIuOClNDjC8ECWTXsLQpZI6dKnlPVUyeWY+RBqJpD8eTlMNfw19AEEKI2wgg4Lr ZOBnBhcssOCf62AggQwaZLBABB5kWN49OygAwKSUBuDCkJJSSqkCScJAaQKdThrAC1S+EICmk4Kq hwuotgpAHjkIkGqS0uhA6aVsstoqp/wIKCdMvEG4gYgP1AfPCBWwcEJb7ozgoGUajGCcY8npeI8O sroKAK+3JKAtAAlMyYOtt0rzgqj+MOjRQ6auCjClrt++ikeskyqQD7mWsumttuHuEyeBDnWgAJ6D ZBDeCYRWcILCFXCwDowlNppoChFwQGdD1tazw76TCuCxpqTiwS4AHmdbrx7kiqqDHucCMOqqmgbw 8aeZuHCqywHInPPOsGar6rXl4jOyzCYDsIC/JHS0HjkQuGCBNc6qoLAFJ1B9AgsVqDDCCRdYYIEK FrRVDQqMwpQxPfBaqgOXmQoQ5LiVKrC2DuwGkC4eKac6pacu3w33pnPb7LICpcDrgphilikmrPva iw++uNoDw83b6rAD3ZSvnI+vAD+ETdMQcjAC1V+fULXCpqOuggoLC+YnBw9A4AH+iCU9umW2dquL QZZ5sBs5HvA6zgPfmkbecu54cCw88HLDPKnm99C77b1B28Pu8jywm8BSSo/kjaEotJUB61Z7bUEF 6KdvetVaRxujC3yRdDbKm9Iqzc0CrGnKzQlomTelmuPby/CAP/3VQ3AAuJv9eCC9BSwQb9UbksmS 1APcPXBAoCEIhj7SgdM8AAVV81oFLmAAEhrghAUooQEqcMIKeK1rKkhBd9YykvnlAV5+s8cOaEal TAVAc/gSAP4wIcC75YCHSjrgzXQmxBzOK1vcsgfkruWzenAMehthSl4ck5ZqAOoApDNhAQZwgQsU oAAcOCMJU3jCC6zvAMZqCJ3+bAg8AFLvZFTSFfIg5zseHO9uAsSePeCFKicyMFtHe1wEpTE5PEqD XYbkSgbVEzCnOMuEAxgAAtR4xhEMQIUDGCMb0ccsRwlNVAas1aYOSKm74esF0gNAmUQVspZNTx+E 1JQhpRfFeqTsd4y8GTBF1srNJe0nDqEhW9QYykye8IShZGMAoonCodCxB/DCoi9XiTaV4YF4l0Kg 29D1TW7mQ5wJSGcCtMnAfW1PkS4bZh5gAMV6QHJzWsRNMq+xH3ak0QBnPOEIBjoCDohuoNAEKBph Ehc6+rGY+OgBEvWwLwEAUVS44ti+Bpiyd57Tjvjg5QV/ScVUWRGk9/gXFyP+QxhuZCCgGbBYONoT DnCIDqDi+xM8amg7+plUGjsQVwGByj//YfSJqEIeD5bITm1mc0h6ECk8ASDPW5hMXJ5YIvfOwh6F dEMEJSgBCcTqArCKNaxhJcFY0TpWtZoArGulgQguJpee9oxSIctEOvN6vUeak6R4sCU5kzdRHrhA AC54183YeTtHShGvmbCnOYn508Xkk5J7UYgNeuCDzvpgB54NrWhHO9oe4MBsdr1h3HRQpo3iKmUB kFuZFLBEv01RrzGzbaUSAAPWaq9wm/KScGXgJf9VVLguEO4LLpoq5SrXSTqgnAKaZKXMLYVWneNG e26ggwhIwLszkIB4JTD+Ae+K17veLe93x5teCfzABqjNRyxdJkRd9i5m9Z3sbTNBuQFSVlQzm1Qi DVupnRl4gNI78M6oiom8KThnIRtafh2b0st+iCTcjcAEJkABCkxAAh7ecIdDvGEQj3gGG06xDmyA o4g4FG9FQ9XverCAb/0MgvFU5WBxy6+BIPBbuJqvq1zQ4Hi5LGQ94FirbmxZ7NJOAzDwgYY5TF4K kDfFHR6vlSXAHQh4+MoSmAGL5ZdaPWysVQIwJDYpd6tQTWqYPjTkjyllAmnkcshIjRcGihwv/xK4 VUTu1SQvLJ2DbMAG3Q3xlkn84Qcs4AAIWMADDkDpA0BAvCUWc4sd8uL+qBYJS5FUUgxMoIDp2qNK Ykol4rCaCSuV+m1bQpysZ00Lxc1a1j64xa1vzWoY9OhN/eDcBj+S4Q9bucMl3jAEEMBsBFTa2ZBe QJUlsOJNY6zMHMo2QFTqvRtImcQehsABFvDoR0PaAJRGd6UXheIZaJrM2o53Rjj3ZERP2djfFeH6 mF1pSB/AAItC9gSqDW95G5wlFv7VSKI8ZRCb+N/oM0CzD1CBdPf70ht+r7XrevCOw2nQe6DdBoqd YhG7wHRYg7azoe1vSido4DaQGAc10GmP25zbI7FBDiJA4u9GIAUG2Hez+a1yGl06zGPmqc2Xbtnu jaTYVRZOCg5wgqD+o3vlWCf6AcZLcKWfZNeMbfWuZc3qPOxATC8oO5cSN89Un/rTwL6Hr0udpQta BOciucHOFZ2CE4BwfX5HgcSHfkJKIyAFH+66SGrODxsbcodGzis9iNfL/2pOquoa2SLzgK0llx0j eA+JvbFsogr8fYULOwECJD74cbv8w++VeY6w7Q8jMxny8ZI8UHGH1Rxs9K7bEtKZtSVIwSY17HdP eHYN4u17f1cAbETAJwE6AAgAfN3mJa97k7542vcjZjjTlEdNEbNTLdjPeYRoHmwpPMx7QskLjqCD c6Ypd6WE3t3ubslbxEIWLoxhD8B6J7R6GJd48DVztYMSlOI2XqL+ACaTL/OygF3iXLCED8QzYJZn dvU0T6vFJRo1JSbjNjmgAz8mSBcResT2bSVGAVfDAi74giqAAquXbitXIyWmeLOngAKWeZ9SCrhn gvrge6IyJUJIMgPhfiYjeUkmANMVDSmTPz5FMql0F8o3bA6RAaPHYR0meAjwgixwQhawAAgQKBL3 by/3YWIWXydRWDyAO3eDe9ujCf6AQ5wXQbwEK5+SJJfjVzkmDRuleycIctRAO/bmYSMmgyjghehD NpVWeA/gXV+mcQWnEWwILyGDewGQTh5TVfXQSLeETd4EfNxiS5yoB7jDTuCEEvj3dIkmYiyoLKqH AFfjdxTgaCP+JGlHV2IaRzuMtw9sCFi4hyqVhyYcY1V6E1Ub+GdKhQ9DRA9H9GaqWIUYtnNYRgGJ yALSVwBdyAIowGUlhAC5iGU4+BG9qA+/GDTPuCtzWEzpqHuYF2dKcmAJREAdUw8SRWGB6GTek4Va 2IKZNEZX040SkABldGUpBmLvpYaUWFl1CI3kJyrqlAClSA/RZVJ6pE07AEXRoEeS1yoh04xANVmg J4hP1nwrOAGzmEmZpDAoEF5wZGmMtmErJnvk6H2Nx5B1NCmXKJL/UIwa2Vi39FAOiQceiQe4Y0Cp eBKrGBIb0FsaZogJ8G/S10wIwEKLMoAQgGIiJl6SKEcGUY7++VBYGdkxmgOHF4FApOiMP8lASLQu C8Axd+NDcEZL0aiPTydlK/gApqOSKml6P2JCCzADMTmOLmaTvsiQOaA90YB7GAgQOYA/ZKmW9TIQ S6R7egRIPRiFUKiUJIlhrdhhKeCCUylKAalC6BYBKGaQXdl9OgguiuMCHKNUcGhrisNa/KBk4FIP 7gcviJUDI4hA/WKUn9IkOfACJgOEVNgRVggVI/dtFDADL4ACq5NJq3dGJwA2JtRGLKJ9ExB7k5gR 9Ud/xRNV5adg44cPplIpgHhIk6mB9ZcARfM7xENfRbOZnOl0TNl8FPADLLACqxOD6+M1q2M6ZXQB o7MCMjD+bYTJaYZpjt8yKsJnZLnJD5Rjf0+SjDD2LZV3Z5USaslnl/mpAxAQASiwAiZ6oivQnyhq ogJqojHUYe62mi11ba2ZVLyzJRIqAP2gUfbwmO2JMjWWVLCmLvS0ZFMYiPiZTArBXQSQAKuzoiv6 pCrgn1PqnyjgABDgAA0AAzawnDT6dWCSOLhgj12CdhMoa8j3JGV6pGg3hTnwa02ID5fza3XXIZ05 EiLQAw6wABcgnf/Zn/+JolXqojHEAATAAA6gAyTwZGDJdNm2lCGRAWfHAA2wANcJpShqAQeAAtJp ogtAAA6gpTKQAyLAqA3qqI+qfDJxMSWwAxBAqVi6pyn+YDUqgAHFQQCg2gANQAANEKq72gA5YAPx 43WoWqyQKhI64ANaiqu6uqu86qy5yqzLSqkQsDb2oZDF6qj09mQaIAKXE6pa2qzi6qyUqqvP2qs6 0APjYUrZiqrHKhLemgMOUK7jWq/NygAMoAA5sAOlShON2q7mgYJ4ugM5IAPzWq/02gD42qsxQLDr 6q+nCrABK41B8QGb5QMGS6m4urAbi6gy4AM9cAM0ia0S23ECy5TcIAIr4wM6EAPWoaVYKgMykKw9 YANzxa1fGbElWxvvShMeoHezAFq+GVQ84AMiO7IQu7M3d6eG5rNgdQM3QAMlIAIeIBrKJBT/qrSd cbKoM8pQ7REZLPUYJHETWmuyTFsYl/EWX2ESZStvwsYfyREXdOU5NVVodlto4OAfbcshPYu27YCz LrYZe6ttXOu3hmsTOju4dtG3hTG3QqEZiku4qnq47MFF/RECfzAIf/ABfbC5ncu5mwu6npu5ofu5 fvC5pku6pxu6q9u6pau6ouu6qKu6qSu7r0u6fdABiGC7qGsTHVFTgxC8wju8xFu8xnu8yDu8HxAE ADs= ------=_Part_396162_1485334581.1370254381447-- ------=_Part_396161_362836402.1370254381447--