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