Hi

I'm using excel 2000

I have a spreadsheet for calculating Overtime

A = Hourly Rate
B = Single Time Hours
C = Single Time Cost
D = Time and a Half Hours
E = Time and a Half Cost
F = Double Time Hours
G = Double Time Costs
H = Total costs

In columns C,E and G I have the following formulae

C =IF(B3="","",SUM(B3*A3))
E =IF(D3="","",SUM(A3*D3)+(D3/2*A3))
G =IF(F3="","",SUM(F3*2*A3))

which calculate the cost of overtime, but leave the cell blank if no
hours are enterred in B,D & F

The problem I have is that unless I enter an amount in all three hours
columns I get #VALUE! in column H where the formula is =C3+E3+G3

How can I get rid of the #VALUE!, but keep columns C,E & G showing as
blank

Thanks in advance for any help


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=475314