Most solutions I've seen use an If(True,DoX,ElseDoY) formula. More to your
problem, but generally you need to enter something like:

=IF(iserr(YourCurrentFormulaHere),"",YourCurrentFo rmulaHere)

HTH


"Paul Sheppard"
wrote in message
news:Paul.Sheppard.1ws4ue_1129104307.4895@excelfor um-nospam.com...

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