Thread: If Function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default If Function

Just bear in mind that "" (the empty string) which appears as a blank, is
not the same as a blank meaning nothing at all in the cell. Functions such
as COUNTA and COUNTBLANK will count the empty string, but not a truly empty
cell, a blank.

Tyro

"suemarie" wrote in message
...
Is it possible to use an IF function to do the following

If cell C2 "is blank" then return the value in C3, if not then do nothing.
I guess my question is can "is blank" be used in an IF function.