Thread: if function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default if function
Hi Richard

Do you want to test if every cell in A1:E1 is less than .5 or not have data

Try this in F1

=IF(MAX(A1:E1)<0.5,1,"")


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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