Thread: If Statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC Rippstein hotmail com> KC Rippstein hotmail com> is offline
external usenet poster
 
Posts: 168
Default If Statements

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!