Thanks a lot for the suggestion it worked out!


On 06/03/2013 01:13 PM, Luis Iglesias wrote:
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:
or maybe you're looking for something like:

De: "Явор Маринов" <>
Enviados: Lunes, 3 de Junio 2013 11:18:35
Asunto: Problem with a formula


I'm having a problem with a formula that i have


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:
For additional commands, e-mail:

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