Neg. Number

[aapjrat5128]

I have the following formula in E58
=IF(ISERROR(C58/D58),””,C58/D58)
My problem is that there is a number in
D58 but not in C58 and I get a negative number,
Is there any way that I can change the formula?
So that I can get a zero or blank.

 

[aapjrat5128]

MILEAGE ON 97 BUICK PARK AVE..xls
	A	B	C	D	E
53	Date	Miles	Diff	DaysElapsed	AverageMilesperday
54	6/27/2002	70,565.00	1,029	31.00	33.19
55	7/27/2002	71,587.00	1,022	30.00	34.07
56	8/27/2002	72,795.00	1,208	31.00	38.97
57	9/27/2002	74,032.00	1,237	31.00	39.90
58	10/27/2002	75,112.00	1,080	30.00	36.00
59	11/27/2002		(75,112)	31.00	(2422.97)
60	12/27/2002		0	30.00	0.00
61	1/27/2003		0	31.00	0.00
Mileage on Buick

 

[jtfourh]

why don't you change the formula in C so that it reads if there is anything in column b before it computes to the negative?

 

[PaddyD]

your difficulties stem from an inappropriate use of the iserror checks. You are attempting, I assume, only to calculate when it's appropriate - i.e. when the cells concerned have data in them. iserror is not going to do that for you - it's going to check for errors (no surprises there!). blank cells / zro values are not errors. One method to check for whether a cell has a value is with a len() check - it there's nothing in a cell, len() retuns zero. as zero is also understood as false by excel, this method can be used in if() statements.

consider changing your formulas from things of the form:

=IF(ISERROR(B54-B52),"",B54-B52)

to one like:

=IF(len(b52),B54-B52,"")

and see what you get.

paddy