View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formula in Excel Help Please

Hi,

This is far from clear but try this

=IF(COUNTA(F4:K4)=6,62.5,0)

Mike

"TMansell" wrote:

I need a formula the says, If these cells F4:K4 have blanks then they = 0 if
there are no blanks then = $62.50. How do i do this?
--
TMansell