Here is what I'm trying to do, and I can't seem to get a formula or If
statement to work.

If C4 is blank, show nothing, but if C4 has a value, C4*.01

Please help!

A couple ways:
=if(isblank(c4),"",c4*.01)
=if(c4="","",c4*.01)

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Abby Dabby Doo" wrote:

Here is what I'm trying to do, and I can't seem to get a formula or If
statement to work.

If C4 is blank, show nothing, but if C4 has a value, C4*.01

Please help!

=IF(C4="","",C4*.01)
--
David Biddulph

"Abby Dabby Doo" wrote in message
...
Here is what I'm trying to do, and I can't seem to get a formula or If
statement to work.

If C4 is blank, show nothing, but if C4 has a value, C4*.01

Please help!

Thank you, Thank you, Thank you!!!!!

"KC Rippstein" wrote:

A couple ways:
=if(isblank(c4),"",c4*.01)
=if(c4="","",c4*.01)

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Abby Dabby Doo" wrote:

Here is what I'm trying to do, and I can't seem to get a formula or If
statement to work.

If C4 is blank, show nothing, but if C4 has a value, C4*.01

Please help!