'IF' mixup

[Pr0]

Hi.

I'm trying to solve this:

In C9

IF D9 is empty AND C8 is empty THAN 1
IF D9 is empty AND C8 is not empty THAN C8+1
IF D9 is not empty AND C8 is empty THAN do nothing
IF D9 is not empty AND C8 is not empty THAN do nothing

The C column is a numerical counter and is suppose to auto increase depending on the D column having something or not. When it finds a D cell with data inside, than the corresponding C cell returns empty and auto resets the count. It should look something like this:
example.jpg

I know this much:
IF D column has something THAN do nothing

I started with =IF($D9="","1",""), but I know it's not enough so I tried to understand how 'IF AND' / 'IF OR' work, but I just can't figure it out... :/
Help, please.

P

Please Login or Register  to view this content.

[joeu2004]

Try:

=IF(D9<>"", "", IF(C8="", 1, C8+1))

Forgot to mention.... Do not put quotes around numbers if your intent is to treat them as numerical values. "1" with quotes is text; 1 without quotes is numeric. Although numeric text ("1" with quotes) works in numeric expressions, it is not always treated as numeric.

[kev_]

Try:

Please Login or Register  to view this content.

[Pr0]

Problem solved.
Thank you.

P

[Pr0]

It returned #VALUE! (A value used in the formula is of the wrong data type.) error.

P

[Pr0]

Try:

Please Login or Register  to view this content.

It returned #VALUE! (A value used in the formula is of the wrong data type.) error.

P

[Pr0]

Try:

=IF(D9<>"", "", IF(C8="", 1, C8+1))

Forgot to mention.... Do not put quotes around numbers if your intent is to treat them as numerical values. "1" with quotes is text; 1 without quotes is numeric. Although numeric text ("1" with quotes) works in numeric expressions, it is not always treated as numeric.

Problem solved.
Thank you.

P

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Pr0]

Yes of course, forgot about that.
P