On Aug 1, 10:10 am, Farhad wrote:
Hi,

Try this:

=IF(ISBLANK(F8),F7,IF(F8=0,F7+1,F7))

This formula repits the number when F8 would not be zero (balnk or negative
or positive)

hope it will work for you,

Thanks,

--
Farhad Hodjat



" wrote:
This is probably a simple question... but, I'm trying to get a
spreadsheet to fill in a number if there's something in the field...
the column that will populate the number is column D... for example,
the data can be entered column F, rows 7-49...

Right now, I have it set that if there is something in cell F7, put a
1, if not, leave blank. The next field, however, depends on the one
before... so, my formula is...

=IF(F7=0,"",1)

then...

=IF(F8=0,"",D7+1)

This formula continues down the column but because it's dependant on
the row before, if someone skips a row, they get #VALUE... is there a
way to make it count even if they skip? So, if they put something in
F7 but leave F8 blank and then fill in F9, D9 will show as number 2
since F8 had no data?

That's confusing... sorry! Hope you can understand what I'm
asking :) Thanks!!- Hide quoted text -

- Show quoted text -

This doesn't work... this is actually making the D column just show
whatever is entered in the F column in the previous row, UNLESS the
field is blank, in which case it makes it a zero... (the F column is
an account number so it will be a number)...

Basically, this is for agents to track calls - the problem is, they
often times accidentally skip a row. I want the tracker to just count
for them... 1, 2, 3 (etc) in sequential order and just leave it blank
if they skip the row but still continue the sequence when they pick it
back up.

So, I need it to be blank if there is nothing in the field and be the
next number in sequence if they do type something in the field.

Any ideas?

Thanks!