Thread: values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dajaal dajaal is offline
external usenet poster
 
Posts: 1
Default values

Hi
I want to set a cell as follows

if cell a1 =3 then cell b1 must return x
but i want to restrict cell a1 to be less than 10 as well. in other words
cella1 must be greater or equal to 3 but less than 10.

PLEAAASE Help.