If Blank

[Dans Issues]

Hi all,

I'm completing a formulae for a date, lets say:

Date of assessment H3 = 2022
Date of Birth K5 = 1978
Age L5 = 44

I have sorted this (L5=H3-K5), however, if K is blank I do not want L5 to return 2022 I would like to to return blank or -


I have Tried =IF(K5=",",H3-K5) or =IF(ISBLANK",",H3-K5) from other posts however I have no joy, I either see "False" or "computer say no"

Can anyone help?


Thanks

 

[jtakw]

Hi,

Use one of these:

=IF(K5="","",H3-K5)

=IF(OR(K5="",H3=""),"",H3-K5)

The 1st one only checks if K5 is blank, if so, return blank.
The 2nd one checks both K5 and H3 for blank, if either is blank, return blank

 

[Toadstool]

Hi Dans Issues,

Try

=IF(ISBLANK(K5),"",H3-K5)

 

[Dans Issues]

when I pull the formulae down the below number are minus as H3 is altered to H4 and so forth
How do I Lock H3 as H3 (2022) is constant.

 

[jtakw]

Use these:

=IF(K5="","",H$3-K5)

=IF(OR(K5="",H$3=""),"",H$3-K5)

 

[Dans Issues]

You are a Gentleman,

Formula complete

 

[jtakw]

You're welcome, thanks for the feedback.