if statement between values

Q

Qaspec

how do i enter this as a formula?

if r46 is between 37987 and 38017 then 1 else 0

thanks for any help
 
R

Ragdyer

Try this if you really mean *between* 37987 & 38017:

=(R46>37987)*(R46<38017)

If you want to *include* 37987 & 38017, try this:.

=(R46>=37987)*(R46<=38017)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Page numbering with Merged Document and IF statements 1
Newbie Help - IF Yes No Function 0
VB code. If statement between two values 1
If value between 2 numbers 7
I need to place a rule between columns 0
counting cells that are >0 in a range of non-contiguous cells 9
return multiple values when within range (greater than and less than) 11

Top