View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jac007 jac007 is offline
external usenet poster
 
Posts: 11
Default If a Row is blank

I would like a formula that will indicate if a row is blank or not.

this function in cell K2 {if A2:J2 is null, then put "Remove", else "Keep".}
so if that range is blank then put "Remove" if C2 has a value then put
"Keep" in K2 cell

How would I do this?