include error checking

[Paul]

=SUM(N71-(T71/1.4))*BJ71

If BJ71 does not have a value the error #VALUE appears.

I have tried to incorporate error checking into the formula without much
success. Anyone know what is needed?

Thanks in advance.

Try this:
=IF(BJ71="","",SUM(N71-(T71/1.4))*BJ71)
It will display nothing until there is something in BJ71.

 

[Pat]

=SUM(N71-(T71/1.4))*BJ71

If BJ71 does not have a value the error #VALUE appears.

I have tried to incorporate error checking into the formula without much
success. Anyone know what is needed?

Thanks in advance.

 

[Bob Phillips]

Pat,

Are you sure it doesn't have a value? When I try it, I get 0.

I think it may have a space in there. Try it with this in another cell
=LEN(BJ71). Is it 0?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Pat]

Thanks Paul that worked.
Here is a similar formula which has another cell included. Its not quite
right do you know the right formula?

=IF(CV92="",""&IF(CW92="","",IF(T92="","",SUM(N92-(T92/1.4))*(CW92+CV92))))

 

[Roger Govier]

Hi Pat

Is this what you mean
=IF(CV92="","",IF(AND(CW92<>"",T92<>""),(N92-(T92/1.4))*(CW92+CV92),""))

 

[Pat]

Hi Roger,

Nice to here from you again!
Your solution I am afraid has not worked.
The solution provided by Paul earlier when modified is what I want I think I
need.

=IF(BJ71="","",SUM(N71-(T71/1.4))*BJ71)

His formula only returns a value if there is a value in BJ71 (or in the case
of my last formula example provided CV92)
What I want now to do is include another cell and also check to see if there
is a value in that cell (that cell being CW92)
If there is a value in both CW92 and CV92, these two cells are added
together. If either one of cells CW92 or CV92 does not have a value the
formula should return a value for that one cell alone.

The formula example
=IF(CV92="",""&IF(CW92="","",IF(T92="","",SUM(N92-(T92/1.4))*(CW92+CV92))))

is a modified version of the answer Paul gave.

regards
Pat