Thread: patterns
View Single Post
  #4   Report Post  
Max
 
Posts: n/a
Default

Placed in F3:

=IF(MAX(F1:F2)+1=5,"Exactly 5 consecutive
numbers",IF(MAX(F1:F2)+15,MAX(F1:F2)+1&" consecutive numbers",""))


Sorry, pasted the wrong formula above for F3
In F3 should be:

=IF(MAX(F1:F2)+1=5,"Exactly 5 consecutive
numbers",IF(MAX(F1:F2)+15,MIN(MAX(F1:F2)+1,8)&" consecutive numbers",""))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----