Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if statement between values
how do i enter this as a formula?
if r46 is between 37987 and 38017 then 1 else 0 thanks for any help |
#2
|
|||
|
|||
=IF(AND(R4637987,R46<38017),1,0)
Vaya con Dios, Chuck, CABGx3 "Qaspec" wrote in message ... how do i enter this as a formula? if r46 is between 37987 and 38017 then 1 else 0 thanks for any help |
#3
|
|||
|
|||
Try this if you really mean *between* 37987 & 38017:
=(R4637987)*(R46<38017) If you want to *include* 37987 & 38017, try this:. =(R46=37987)*(R46<=38017) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Qaspec" wrote in message ... how do i enter this as a formula? if r46 is between 37987 and 38017 then 1 else 0 thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
project values based on other values | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions |