Thread: IF statement (non nested) that compares cell value against range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
r2d3 r2d3 is offline
external usenet poster
  
Posts: 5
Default IF statement (non nested) that compares cell value against range
Is it possible to write a non-nested IF statement that looks something like

IF(A2=10 AND A2<100,"10-100","") or IF(a2 is between 10 and 100,"10-100","")
Reply With QuoteReply With Quote