Using IF function for inbetween cell values
try
=if(and(A=1,A<=100),"yes","no")
"Ivano" wrote:
Hi,
I would like to test a cell and run a formula if the cell is inbetween two
values. For example.
IF(A1 <is inbetween values 1 and 100,"YES", "NO")
I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
or 1<A1100?
Thanks a lot for your help,
|