=IF(Q45>0, C45, "") - what is wrong with this formula?

[andy.k]

I got this formula, but its not working.. what is wrong?

=IF(Q45>0, C45, "")

Here is what I'm after.


If cell q45 contains something, then display contents of C45, else is blank

My q45 is empty, but is still displays contents of c45... why?

[Jonmo1]

That wold pretty much mean that Q45 is NOT Blank.
I would guess that it contains a formula that is returning "" <- that is NOT blank, it's a Null text string.

Try
=IF(Q45="","",C45)