ISBLANK help

[nowfalapm]

Hi,
I need a help in this formula =IF(ISBLANK(C4),"",B3+1), in this case if b2 is a blank cell i am getting a VALUE error. I am using 2 colomns B and C about 500 raws, i am using c colum to enter data , in the above formula B colum is automatically filled the serial numbers(1 to 500) . I hope somebody will help in this regard.


Thanks and regards

[Phuocam]

Try this ...

=IF(ISBLANK(C4),"",MAX($B$2:B3)+1)

[nowfalapm]

yes sir, done. Thanks alot.

[AlKey]

You could simplify with

Please Login or Register  to view this content.

[nowfalapm]

sorry sir, zero is still counting , if it is empty balnk cell your formula is ok.

[AlKey]

then try this

Please Login or Register  to view this content.

[nowfalapm]

yes sir(mr.Alkey), done. thanks alot.