It looks like you want the remainder after dividing by 15.

If that's true:

=mod(H4,15)





tmela wrote:

if cell h4=16, subtract 15, if cell h4=31 subtract 30,if cell h4=46
subtract 45
does any one know if all this can be included in one formula?
Many thanks in anticipation of your reply

--
tmela
------------------------------------------------------------------------
tmela's Profile: http://www.excelforum.com/member.php...o&userid=37745
View this thread: http://www.excelforum.com/showthread...hreadid=573580

--

Dave Peterson