Is calculation set to Automatic?


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 05:42:05 -0800, Read
wrote:

This formula copied down column B makes an entire column of bread. It never
recognizes the change to milk? I'm still confused?

"Max" wrote:

Errata, sorry:
In C1: =IF(A2="","",IF(ISNUMBER(A2),C1,A2))
Copy C1 down

Should be:
In B2: =IF(A2="","",IF(ISNUMBER(A2),B1,A2))
Copy B2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---