=if(c1=0,0, thatlongformula)


Dave Peterson wrote:

One way (until Biff comes back with something much smaller!):

=LEFT(IF((REPLACE(A1,1,SEARCH("---",A1)+2,""))
(REPLACE(B1,1,SEARCH("---",B1)+2,"")),A1,B1),
SEARCH("---",IF((REPLACE(A1,1,SEARCH("---",A1)+2,""))
(REPLACE(B1,1,SEARCH("---",B1)+2,"")),A1,B1))-1)&" +"&C1

(That's all one cell--paste in the formula bar with D1 selected)

wally wrote:

I have windows XP 2003 home edition.
I have a name and number in cell a1; john---22, I have a name in number
in b1; James---27, I have just a number in cell c1; "3" (ignore
quotes). In cell d1 I would like to show the name only (from cell a1 or
b1) that has the lowest number along with the number in cell c1. The
end result would look like this; John +3.
Here a sample of what my work sheet looks like and the result I am
seeking.
a1 b1 c1 d1
John---22 James---27 3 john +3
a2 b2 c2 d2
Joe---90 Betty---60 4 Betty +12
etc, etc down through a8:d8.
If a zero appears in column "c", then no name appears in column "d"
just a zero without the plus sign.
The range I am working with is a1:d8.
Thanks for any help you can provide.
WallyB

--

Dave Peterson

--

Dave Peterson