Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openoffice.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Date: Mon, 3 Jun 2013 12:13:01 +0200 (CEST)
From: Luis Iglesias <luis.iglesias@vigo.org>
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"

------=_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

<html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><=
div style=3D'font-family: Verdana; font-size: 10pt; color: #000000'>Hi.<br>=
The problem is not with fractions but with the values you expect in your co=
nditional. Your formula only applies when A23 &lt; B9 or when A23 =3D (1,2,=
3,4,5,6,7,8). You can fix in your last IF:<br>...IF(A23=3D8;$F$16;1)...<br>=
or maybe you're looking for something like:<br>=3DIF(A23&lt;$B$9;$F$8;IF(A2=
3&gt;8;$F$16;IF(A23&gt;7;$F$15;IF(A23&gt;6;$F$14;IF(A23&gt;5;$F$13;IF(A23&g=
t;4;$F$12;IF(A23&gt;3;$F$11;IF(A23&gt;2;$F$10;IF(A23&gt;1;$F$9;1)))))))))*A=
23*D23<br><br><br><hr id=3D"zwchr"><b>De: </b>"=D0=AF=D0=B2=D0=BE=D1=80 =D0=
=9C=D0=B0=D1=80=D0=B8=D0=BD=D0=BE=D0=B2" &lt;ymarinov@neterra.net&gt;<br><b=
>Para: </b>users@openoffice.apache.org<br><b>Enviados: </b>Lunes, 3 de Juni=
o 2013 11:18:35<br><b>Asunto: </b>Problem with a formula<br><br>Hello,<br><=
br>I'm having a problem with a formula that i have<br><br>=3DIF(A23&lt;$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<br><br>If the content of A23 is integer the formula works fine, but=
 if the <br>content of A23 is =D0=B0 fraction the result is 0.<br><br>Can a=
nyone point where can be the mistake?<br><br><br>--------------------------=
-------------------------------------------<br>To unsubscribe, e-mail: user=
s-unsubscribe@openoffice.apache.org<br>For additional commands, e-mail: use=
rs-help@openoffice.apache.org<br><br><span><br><br>-- <br><span name=3D"x">=
</span><span><span><font size=3D"1"><strong><em><span style=3D"color: rgb(1=
15, 115, 115);"><font size=3D"2"><span><span><font size=3D"1"><strong><em><=
span style=3D"color: rgb(115, 115, 115);"><font size=3D"2">Luis Iglesias Re=
jas<br>Servizo de Administraci=C3=B3n Electr=C3=B3nica<br>Praza <span class=
=3D"Object" id=3D"OBJ_PREFIX_DWT2503">do</span> Rei, 1 - Planta 7=C2=AA<br>=
36202 VIGO<br>Tfno: 986 810 159 / Fax: 986 220 341 </font></span></em></str=
ong></font></span></span></font></span></em></strong></font></span></span><=
br><span><span><font size=3D"1"><strong><em><span style=3D"color: rgb(115, =
115, 115);"><font size=3D"2"><span><span><font size=3D"1"><strong><em><span=
 style=3D"color: rgb(115, 115, 115);"><font size=3D"2"><span><span><font si=
ze=3D"1"><strong><em><span style=3D"color: rgb(115, 115, 115);"><font size=
=3D"2"><span><span><font size=3D"1"><strong><em><span style=3D"color: rgb(1=
15, 115, 115);"><font size=3D"2">Web: </font></span></em></strong><font siz=
e=3D"2"><span class=3D"Object" id=3D"OBJ_PREFIX_DWT2504"><a href=3D"http://=
www.vigo.org/" target=3D"_blank">www.vigo.org</a></span></font></font></spa=
n></span></font></span></em></strong></font></span></span><br></font></span=
></em></strong><font size=3D"2"><span class=3D"Object" id=3D"OBJ_PREFIX_DWT=
2504"><a href=3D"http://www.vigo.org/" target=3D"_blank"></a></span></font>=
</font></span></span><img doc=3D"Briefcase/logo_concello.gif" src=3D"cid:DW=
T109"><br></font></span></em></strong><font size=3D"2"><span class=3D"Objec=
t" id=3D"OBJ_PREFIX_DWT2504"><a href=3D"http://www.vigo.org/" target=3D"_bl=
ank"></a></span></font></font></span></span><span name=3D"x"></span><br></s=
pan></div></body></html>
------=_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: <DWT109>

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--