How about =INDEX(A1:C1,1,MAX(IF(ISBLANK(A1:C1),0,COLUMN(A1:C1))))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry" <nosoup4yew@yahoo.com> wrote in message
news:1133298843.999594.231560@g43g2000cwa.googlegroups.com...
> But for some reason I can't get it to work. Here's the spreadsheet
> setup:
> I've got three columns of data that each describe a single transaction
> during separate stages. I've got another column that I'd like to use
> for determining the most up-to-date stage total. So, I came up with
> the following formula:
>
> IF((AND(A1<>0,B1<>0,C1<>0)),C1,(IF(AND(A1<>0,B1<>0),B1,A1)))
>
> The idea was that if there's a value in columns, A,B, and C, then the
> 'total' would read from column C (the most up-to-date), but if no value
> in C, then it would read from one of the other two based on which had
> the more current data. However, I noticed that sometimes my data skips
> a stage, so I may not have info in columns A or B; resulting in no
> value for the total. I've tried the above equation with "OR" instead
> of "AND" as well, but to no avail.
>
> Any ideas?
>