how do i create a divisible formula

[Tim]

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.

 

[Mike H]

Tim,

Try this in F10

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

Mike

 

[Lars-Åke Aspelin]

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.

Try this formula in cell F10:

=IF(MOD(B5,15)>0,"error message","")

Hope this helps / Lars-Åke

 

[Huber57]

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