Hey Thanks for the response,
Sypher2 & SkipVought
the formula =IF(BL7/BL$5>1,1,BL7/BL$5) seems to work
the way i end up with BL7 that is the total amount of calls
the fireman " A " has made for the year night & day calls
Fireman "A" is considerd a night time fireman
say...