Input result when 2 cells conditions are met

Hi

Can you clarify wath is range C2 to Z? or C2:Z2?

But if it is C2:Z2 then H2 as parte of that range (circular reference)

Regards

hi..

please check below formula

=AND(NOT(ISBLANK(C2)),(LEFT(F2,4)="001-"))

best regards,
JRD

Originally Posted by José Augusto

Hi

Can you clarify wath is range C2 to Z? or C2:Z2?

But if it is C2:Z2 then H2 as parte of that range (circular reference)

Regards

Hi Jose,

I apologize for the confusion. C2 to Z means from Range C2 to until there is no item (i.e C2, C3, C4....)

JR, you code is what I expected, but is there a way to input CONFIRMED as TRUE and "blank" as FALSE as result instead of just TRUE/FALSE?

Thanks guys

Originally Posted by José Augusto

Hi

Can you clarify wath is range C2 to Z? or C2:Z2?

But if it is C2:Z2 then H2 as parte of that range (circular reference)

Regards

Hi Jose,

I apologize for the confusion. C2 to Z means from Range C2 to until there is no item (i.e C2, C3, C4....)

JR, your code is what I expected, but is there a way to input CONFIRMED as TRUE and "blank" as FALSE as result instead of just TRUE/FALSE?

Thanks guys

Originally Posted by bebo021999

=if(and(c2<>"",left(f2,3)="001"),"confirmed","")

How about the opposite?

1. If there is "something" in the range C2 to Z
AND
2. If the range F2 to Z is other than "001-"

Then Range H2 to Z will have CONFIRMED as result (True). False is "blank".