View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
king60611 king60611 is offline
external usenet poster
 
Posts: 9
Default IF Formula Question

I need: If column X is blank, use the value in column U; otherwise, the value
is 0.

I wrote: =IF(X3=" ",U3,0)

Unfortunately, it's returning 0 for everything, even when X is empty.
What's the correct formula I should be using?