Thread: Formula not being Friendly
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Living the Dream Living the Dream is offline
external usenet poster
  
Posts: 151
Default Formula not being Friendly
ok

Rule 1. =I1="Breached"
Rule 2. =I1<=0.375
Rule 3. =IF(I1<=0.625,AND(I10.375))
Rule 4. =IF(I1<=1.25,AND(I10.625))
Rule 5. =I11.25

HTH
Mick.
Reply With QuoteReply With Quote