IFS and ISBLANKS formula

[lpaulg3]

How do I write this formula?

If B2 is blank, do nothing
If B2 is NOT blank AND H2 is blank AND L2 is blank, TODAY()-B2
If B2 is NOT blank and L2 is blank and H2 is NOT blank, H2-B2

My rough draft:
if isblank B2 "", if B2<>"" and isblank h2 and isblank L2, today()-B2,if B2<>"" and isblank L2 and H2<>"", H2-B2

 

[AlanY]

what if L2 is not blank?

 

[lpaulg3]

what if L2 is not blank?

How do I write this formula?

If B2 is blank, do nothing
If B2 is NOT blank AND H2 is blank AND L2 is blank, TODAY()-B2
If B2 is NOT blank and L2 is blank and H2 is NOT blank, H2-B2
If B2 is NOT blank and L2 is NOT blank AND H2 is NOT blank, H2-B2
If B2 is NOT blank and L2 is NOT blank AND H2 is blank, L2-B2

My rough draft:
if isblank B2 "", if B2<>"" and isblank h2 and isblank L2, today()-B2,if B2<>"" and isblank L2 and H2<>"", H2-B2

 

[AlanY]

try this

=IF(ISBLANK(B2),"",IF(ISBLANK(L2),IF(ISBLANK(H2),TODAY()-B2,H2-B2),IF(ISBLANK(H2),L2-B2,H2-B2)))