excel formular update
 

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)

excel formular update
 

Hi!

Change "" to zero:

=IF(AND(D1=1,D1<=12),135,0)+B1*C1

Biff

"bluesky" wrote in message
...
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)