Tim,

Insert this formula into F10:
=IF(B5/15-INT(B5/15)0,0,1)

This will return a 1 or a 0 depending on whether or not it is divisible by 15.
You can change the 1 and 0 to any message you would like, just use quotes if
it is text.

Doug

"Mike H" wrote:

Tim,

Try this in F10

=AND(B5<"",MOD(B5,15)=0)

Mike

"Tim" wrote:

I use a xl doc that has numbers in the cells that need to be divisible by 15.
Can i incert a formula that will check the number in B5 and display an error
message in F10 if the number in B5 is not divisible by 15.