Another Excel Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elusiverunner - 12 Jan 2006 01:10 GMT

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 ??

Signature

Steven.

In God we trust, all others we virus scan.

Reply to this Message

Bob Umlas - 12 Jan 2006 01:18 GMT

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

> Hello All,
>
[quoted text clipped - 11 lines]
> an error in my formula - can someone help with a formula and what it means
> ??

Reply to this Message

Roger Govier - 12 Jan 2006 01:27 GMT

Hi

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

Signature

Regards

Roger Govier

> Hello All,
>
[quoted text clipped - 13 lines]
> an error in my formula - can someone help with a formula and what it
> means ??

Reply to this Message