adding to a formula

[Crasher]

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

[mtpsuresh]

Hi,

Try this formula.

=IF(OR(C5=$C$70,C5=$C$72),10*$H$5,IF(C5=$C$71,8*$H$5,0))


Best Wishes,
MtpSuresh

[Crasher]

Hi,

Try this formula.

=IF(OR(C5=$C$70,C5=$C$72),10*$H$5,IF(C5=$C$71,8*$H$5,0))


Best Wishes,
MtpSuresh

did not work it just left the formula showing also it seems the original formula is missing in what you wrote