Formula Help
 

Thanks to Will Cairns who provide me with the following formula.

=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))))

The way it works now, if the text value does not equal "yyyy" the word
"FALSE" is inserted into the cell. Is there a way to change it so that the
cell is left blank if the value of T25 is also blank?

--

Regards
Michael Koerner

Formula Help
 

Michael:

=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))),"")

Alan

Michael Koerner wrote:
Thanks to Will Cairns who provide me with the following formula.

=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))))

The way it works now, if the text value does not equal "yyyy" the word
"FALSE" is inserted into the cell. Is there a way to change it so that the
cell is left blank if the value of T25 is also blank?

--

Regards
Michael Koerner

Formula Help
 

That did it thank you so very much.

--

Regards
Michael Koerner


wrote in message
ups.com...
Michael:

=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))),"")

Alan

Michael Koerner wrote:
Thanks to Will Cairns who provide me with the following formula.

=IF(AND(T25<"",LEN(T25<7)),(TEXT(NOW(),"yyyy")-(TEXT(T25,"yyyy"))))

The way it works now, if the text value does not equal "yyyy" the word
"FALSE" is inserted into the cell. Is there a way to change it so that
the
cell is left blank if the value of T25 is also blank?

--

Regards
Michael Koerner