#VALUE! Error on a Simple Formula

[Snake Eyes]

Greetings,
I'm not quite sure why I can't figure this out...
F13 = 7
O13 = 435
X9 = 22%

This formula returns a blank cell in T13 as expected:

=IF(F13<365,"",O13)

Then this formula gets me the #VALUE! error where I would expect a 0:

=(T13*$X$9)

 

[FormR]

A formula produced blank is not treated the same way as an actual blank cell. But you could try this instead.

=N(T13)*$X$9

 

[Fluff]

T13 is not zero it's "" (which is a text string) hence you get an error as you cannot multiply text by a number.
Change the formula inT13 to return 0 rather than ""

 

[Snake Eyes]

Thanks FormR.
That worked.

Hey Fluff,
I should have also included that I did not want the zero value returned to display. I need that cell to stay blank.

 

[Fluff]

Glad we could help & thanks for the feedback.