You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Явор Маринов <ym...@neterra.net> on 2013/06/03 11:18:35 UTC
Problem with a formula
Hello,
I'm having a problem with a formula that i have
=IF(A23<$B$9;$F$8;IF(A23=1;$F$9;IF(A23=2;$F$10;IF(A23=3;$F$11;IF(A23=4;$F$12;IF(A23=5;$F$13;IF(A23=6;$F$14;IF(A23=7;$F$15;IF(A23=8;$F$16)))))))))*A23*D23
If the content of A23 is integer the formula works fine, but if the
content of A23 is а fraction the result is 0.
Can anyone point where can be the mistake?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Problem with a formula
Posted by Явор Маринов <ym...@neterra.net>.
Thanks a lot for the suggestion it worked out!
BR
On 06/03/2013 01:13 PM, Luis Iglesias wrote:
> Hi.
> The problem is not with fractions but with the values you expect in
> your conditional. Your formula only applies when A23 < B9 or when A23
> = (1,2,3,4,5,6,7,8). You can fix in your last IF:
> ...IF(A23=8;$F$16;1)...
> or maybe you're looking for something like:
> =IF(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
>
>
> ------------------------------------------------------------------------
> *De: *"Явор Маринов" <ym...@neterra.net>
> *Para: *users@openoffice.apache.org
> *Enviados: *Lunes, 3 de Junio 2013 11:18:35
> *Asunto: *Problem with a formula
>
> Hello,
>
> I'm having a problem with a formula that i have
>
> =IF(A23<$B$9;$F$8;IF(A23=1;$F$9;IF(A23=2;$F$10;IF(A23=3;$F$11;IF(A23=4;$F$12;IF(A23=5;$F$13;IF(A23=6;$F$14;IF(A23=7;$F$15;IF(A23=8;$F$16)))))))))*A23*D23
>
> If the content of A23 is integer the formula works fine, but if the
> content of A23 is а fraction the result is 0.
>
> Can anyone point where can be the mistake?
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
>
> --
> */*/Luis Iglesias Rejas
> Servizo de Administración Electrónica
> Praza do Rei, 1 - Planta 7ª
> 36202 VIGO
> Tfno: 986 810 159 / Fax: 986 220 341 /*/*
> */*/*/*/Web: /*www.vigo.org <http://www.vigo.org/>/*
> /*
> /*
Re: Problem with a formula
Posted by Luis Iglesias <lu...@vigo.org>.
Hi.
The problem is not with fractions but with the values you expect in your conditional. Your formula only applies when A23 < B9 or when A23 = (1,2,3,4,5,6,7,8). You can fix in your last IF:
...IF(A23=8;$F$16;1 )...
or maybe you're looking for something like :
=IF(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
----- Mensaje original -----
De: "Явор Маринов" <ym...@neterra.net>
Para: users@openoffice.apache.org
Enviados: Lunes, 3 de Junio 2013 11:18:35
Asunto: Problem with a formula
Hello,
I'm having a problem with a formula that i have
=IF(A23<$B$9;$F$8;IF(A23=1;$F$9;IF(A23=2;$F$10;IF(A23=3;$F$11;IF(A23=4;$F$12;IF(A23=5;$F$13;IF(A23=6;$F$14;IF(A23=7;$F$15;IF(A23=8;$F$16)))))))))*A23*D23
If the content of A23 is integer the formula works fine, but if the
content of A23 is а fraction the result is 0.
Can anyone point where can be the mistake?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
--
Luis Iglesias Rejas
Servizo de Administración Electrónica
Praza do Rei, 1 - Planta 7ª
36202 VIGO
Tfno: 986 810 159 / Fax: 986 220 341
Web: www.vigo.org