ok i hope i put this across properly but here goes

i need the following formula to be modified

=SUM(F5*$H$4)

to add the following

if c5 equals c70 (which says holiday) or c72 (which says Bank Holiday then times 10*$h$5

which should automaticly times h5 (hourly rate) by 10

also if c5 equal c71 (which equals Sick) then times 8*$h$5

which should automaticly times h5 (hourly rate) by 8