=IF(H4=46,H4-45,IF(H4=31,H4-30,IF(H4=16,H4-15,H4))) ' pasted into A1 the
result in A1 is what you wanted tmela.

"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