| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then statement... can't make it work:S
i need some help trying to write a formula that states the following:
if a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then statement... can't make it work:S
=IF(ABS(A1)<5.01,1,0)
or =ABS(A1)<5.01 Hope this helps. -- John C "sed" wrote: i need some help trying to write a formula that states the following: if a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then statement... can't make it work:S
Look in the help index for AND
-- Don Guillett Microsoft MVP Excel SalesAid Software "sed" wrote in message ... i need some help trying to write a formula that states the following: if a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then statement... can't make it work:S
Try
=IF(AND(A1-5.01,A1<5.01),1,0) Mike "sed" wrote: i need some help trying to write a formula that states the following: if a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then statement... can't make it work:S
Thanks again John!
-- sss "John C" wrote: =IF(ABS(A1)<5.01,1,0) or =ABS(A1)<5.01 Hope this helps. -- John C "sed" wrote: i need some help trying to write a formula that states the following: if a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then statement... can't make it work:S
=IF(A1=5.01,1,0)
On Oct 15, 5:52*pm, sed wrote: i need some help trying to write a formula that states the following: if *a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then statement... can't make it work:S
Thanks for the feedback, and don't forget to check the little YES box below :)
-- John C "sed" wrote: Thanks again John! -- sss "John C" wrote: =IF(ABS(A1)<5.01,1,0) or =ABS(A1)<5.01 Hope this helps. -- John C "sed" wrote: i need some help trying to write a formula that states the following: if a1 is greater than -5.01 and less than 5.01 then 1, 0 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can not seem to get my IF / AND statement to work, help please | Excel Discussion (Misc queries) | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| Anyone actually get Case statement to work ... ? | Excel Worksheet Functions | |||
| How can i make this work within an IF statement: (41<=Cell<=46) | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Linear Mode
