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
----
|