=MOD(E1,0.5)=0

[tarynmahon]

How do I determine the result in this instance please?
Currently it either returns TRUE or FALSE but I'd like to specify different text, ie. "Ok" or "Not Ok"

 

[deciog]

tarynmahon

Use this formula
= IF (MOD (E1, 0,5) = 0, "OK", "Not OK")

Decio

 

[tarynmahon]

Took me a little while to work out as should read like this
=IF(MOD(E1,0.5)=0,"OK","Not OK")

But it works, thank you

 

[John Jairo V]

You can try this too:

=IF(MOD(E1,0.5),"Not ","")&"OK"

Blessings!