View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
 
Posts: 510
Default need formula for # names listed * $5

Hi,

Something like
=if(A1<"",5,0)

HTH
Carim