Thread: if function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default if function
=if(A1<.5,1,"")

if you are looking for all values to be less than .5 or blank

=if(sum(countif(A1:E1,{"<.5",""}))=5,1,"")


--
Regards,
Tom Ogilvy



"Richard" wrote in message
...
I want to use a function probably the if function to check if say from
cell
A1 to E1 to see if the value is less than .5 or no data, if true than give
cell F1 a value of 1. How do I write this function?




Reply With QuoteReply With Quote