openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Явор Маринов <ymari...@neterra.net>
Subject Problem with a formula
Date Mon, 03 Jun 2013 09:18:35 GMT
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


Mime
View raw message