Ragdyer" wrote in message
... Try this:

=IF(C5=60,B39*4,IF(C5=40,B39*3,IF(C5=20,B39*2,B 39)))


=MIN(INT(C5/20)+1,4)*B39

Seems to return the same results
--
Regards


Sandy

Replace@mailinator with @tiscali.co.uk


"