Another Excel Formula

[Guest]

Hello All,

Once again I am having problems creating a formula for a worksheet I am
creating. I have three columns - first on is cost of labor; second is cost
of parts and third is total of the two previous columns, no problems there.

What I want to do is if there is no values entered in column one or column
two I want column 3 to remain blank.

I have tried using the "IF" statement, but the result is always that I have
an error in my formula - can someone help with a formula and what it means ??

 

[Bob Umlas]

=IF(OR(A1="",B1=""),"",A1+B1)
Bob Umlas
Excel MVP

 

[Roger Govier]

Hi

One way
=IF(COUNT(A1:B1)<2,"",A1+B1)