Thread: If Statements
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Abby Dabby Doo[_2_] Abby Dabby Doo[_2_] is offline
external usenet poster
 
Posts: 2
Default If Statements

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!