View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jshendel Jshendel is offline
external usenet poster
 
Posts: 24
Default Using multiple IF statements

I need an equation that basically says:
If cell is blank ("" (which is a return of a false statement)), do nothing
and return blank, else run this "IF" equation which has a true and false
return.

I'm trying something like this, but won't work.
=IF(A1="","",IF(A1=B,True,False))
Is it because there is an equation in the reference cell and not "" ?
The equation I tried returns the false statement of the second equation and
not "".