Just a little typo, use this formula

=IF(MOD(A2,4)=0,150,"NA")

Regards,
Per

"Per Jessen" skrev i meddelelsen
...
Hi

Enter this formula in C2 and copy it down the desired range.

=IF(MOD(A2;4)=0;150;"NA")

Regards,
Per

"prem" skrev i meddelelsen
...
How do I check if the content in a cell, when divided by 4, returns an
integer? It should give me 150 if it is an integer and display "NA" if it
is
not an integer.

For example, the formula should check if the content A2 divided by 4 is
an
integer and display the necessary answer in cell C2.

Hopefully the formula can be use to check any corresponding cell in this
manner. I.E check if content in cell A3 when divided by 4 is an integer
and
display the necessary in cell C3, check if content in cell A4 when
divided
by 4 is an integer and diaplay the necessary in cell C4 and so on.

Thank you for your help.