Excel Avoiding nested if statements -

Excel Avoiding nested if statements -

i have datasheet in excel several columns row of data. across these columns have dates. these dates show time item has passed criteria. there way (via formula) way have excel @ each column on line , spit out lastest date.

currently using monster:

=if(x3="",if(w3="",if(v3="",if(u3="",if(s3="",if(r3="",if(q3="",if(p3="",if(o3="",if(n3="","no dates",n3),o3),p3),q3),r3),s3),u3),v3),w3),x3)

it works fine, i'm looking little more elegant.

please , give thanks you.

if want latest date, use

=max(n2:x2)

if want right date, utilize array formula

=index(a2:x2,1,max((not(isblank(n2:x2)))*(column(n2:x2))))

enter array formulas ctrl+shift+enter, not enter. finds largest column isn't blank , inserts index.

excel excel-formula