Using IF function for inbetween cell values
thanks AND thanks AND thanks AND thanks .... get it "AND" : ))
"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,
|