G
Guest
thanks for the help before i worked off the formular i was given to work out
i need the formular like =IF(AND(D1>=1,D1<=12),135,"")+B1*C1 the only problem
is that if there is no number or 0 in d1 it come up with #value! how do i
change this so that the multiplacation of b1 and c1 will still work
i am trying to have it so that i can multiply a casul b1 (hours worked) by
c1 (pay rate). d1 is a full time persons pay the get paid $135 for the day
and work up to 12 hours for that day. i need to only be entering the hours
worked and need a formular that only adds the 135 dollars when the full time
person work when they dont i need to still be able to enter hours for the
casual and have the formular work out the total cost any help would be great
(formular is for each day)
i need the formular like =IF(AND(D1>=1,D1<=12),135,"")+B1*C1 the only problem
is that if there is no number or 0 in d1 it come up with #value! how do i
change this so that the multiplacation of b1 and c1 will still work
i am trying to have it so that i can multiply a casul b1 (hours worked) by
c1 (pay rate). d1 is a full time persons pay the get paid $135 for the day
and work up to 12 hours for that day. i need to only be entering the hours
worked and need a formular that only adds the 135 dollars when the full time
person work when they dont i need to still be able to enter hours for the
casual and have the formular work out the total cost any help would be great
(formular is for each day)