Thanks for reply,

I tried and didn't work. It gives formula error.

Again, I'm looking non-decimal figures.

For example, A1=4, A2= 6, so sum((A1+A2)/5) = 2; therefore the program

should show #2, if it was 2.45, I shouldn't show, since the result has

decimal points.

Thaks,

--

John

OssieMac said:

Hi John,

=IF(MOD(SUM(A1:A2),5)>0,"",SUM(A1:A2))

The above places a null value (which is represented by the double quotes) if

division by 5 does not return a whole number; otherwise will sum the range.

--

Regards,

OssieMac

John Savy said:

Could you show me how to write this program:

if[sum((A1)+(A2))/5] would have decimal points then "blank", not to show

otherwise the result.

In other words I'm looking for the result without decimal point and if the

result has decimal point, it would be out of scop of the purpose, therefore

I'm not interested on the result.

Thanks,