Between

  • Thread starter Thread starter SSeeley
  • Start date Start date
S

SSeeley

I wish to get excel to calculate the following...

A3 = 15

If A3 is between 10 and 20 then Yes, else No...

But I cannot find the funcation that will allow me to use a between tw
values...

Please help...am desporate to finish a spreadsheet off...

Thanks in advance to anyone that can help me...

Stuart Seele
 
I wish to get excel to calculate the following...

A3 = 15

If A3 is between 10 and 20 then Yes, else No...

But I cannot find the funcation that will allow me to use a between two
values...

Please help...am desporate to finish a spreadsheet off...

Thanks in advance to anyone that can help me...
Click to expand...

=IF(AND(A3>10,A3<20),"Yes","No")


--ron
 
Stuart,

"Between" is a function. If you're using an MDB, just put in the criteria
"between 10 and 20" as your criteria.

Ross
 
Hi Ross,

Just curious, what is a MDB and where is "Between" a function?

Regards
Anders Silven

Ross Culver said:
Stuart,

"Between" is a function. If you're using an MDB, just put in the criteria
"between 10 and 20" as your criteria.

Ross
Click to expand...
 
Hej Anders!

MS Access..

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Anders Silven said:
Hi Ross,

Just curious, what is a MDB and where is "Between" a function?

Regards
Anders Silven
Click to expand...
 
Back
Top