What is wrong with this formula?

=IF(TEXT($B5,"mmm")"",TEXT($B5,"mmm"),"")

If B5 contains a date the answer is right, but if B5 is blank it still
returns a value. The expected result is if B5 is blank then C5 is
blank. TIA

Greg

=IF($B5<"",TEXT($B5,"mmm"),"")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"GregR" wrote in message
ups.com...
What is wrong with this formula?

=IF(TEXT($B5,"mmm")"",TEXT($B5,"mmm"),"")

If B5 contains a date the answer is right, but if B5 is blank it still
returns a value. The expected result is if B5 is blank then C5 is
blank. TIA

Greg

Hi Greg,

You can easily check by entering =TEXT($B5,"mmm") in a cell; it returns
"Jan"
Instead, use =IF($B5="","",TEXT($B5,"mmm"))

--
Kind regards,

Niek Otten

"GregR" wrote in message
ups.com...
What is wrong with this formula?

=IF(TEXT($B5,"mmm")"",TEXT($B5,"mmm"),"")

If B5 contains a date the answer is right, but if B5 is blank it still
returns a value. The expected result is if B5 is blank then C5 is
blank. TIA

Greg

Try:

=IF(B5="","",TEXT($B5,"mmm"))
--
Gary''s Student


"GregR" wrote:

What is wrong with this formula?

=IF(TEXT($B5,"mmm")"",TEXT($B5,"mmm"),"")

If B5 contains a date the answer is right, but if B5 is blank it still
returns a value. The expected result is if B5 is blank then C5 is
blank. TIA

Greg

Bob and Niek, thanks once again.

Greg