Excel greater than 1 and less than or equal to 3 is 1, otherwise it is 0, how to express if function

=if(and(a1>1,a1

RELATED INFORMATIONS

1. If function: greater than or equal to 1, less than 15 is 15, greater than or equal to 15, less than 31 is 30
2. 3 meters 2 decimeters = meters
3. One half minus one third plus one fourth minus one sixth plus one eighth minus one twelfth There is also a simple calculation, one half + one third + one fourth + one sixth + one eighth. This is also a simple calculation, and there is also a simple calculation, one-quarter - one sixth - one twelfth. There are three
4. Blood is a kind of () liquid. For an adult with a weight of 50 kg, the amount of blood in the body is about () L. usually, a small part of it is trapped in the capillaries at () and so on, which is called ()
5. Use the equation to express the quantity relationship if 2 times of the number minus 1 equals the number plus 5
6. Three natural numbers, a, B, C, known as AXB = 12, bxc = 15, AXC = 20, then axbxc = ()
7. How to solve the problem of 5 / 6 of X-6 = 8 / 9
8. Help number reasoning 123, 139, 177, 261, 463, ()
9. 18 × 5 / 17 List the calculation process
10. 2.8, 2 and 8 of 7, 1 and 15 of 14, 1 and 20 of 17 and 2, from small to large row
11. How many cattle is 300 kg? Please God
12. How many seconds is 300 hours? How many seconds is 300 hours? Exactly! How many hours is the other 721966 seconds?
13. Add appropriate operation symbols to the equation to make the equation hold 9 = 1000
14. Add a suitable operation symbol in 8 = 5 to make the equation hold
15. Fill in the appropriate operation symbols or brackets on the horizontal line to make the equation true 5 5 5 5 5=5
16. Add appropriate operation symbols "+" - "×" △ or "()" between the following five 5S to make the equation hold 1.5 5 5 5 5=7 2.5 5 5 5 5=8 3.5 5 5 5 5=9 4.5 5 5 5 5=10
17. Add an operation symbol between some numbers of 16 eights to make the equation hold 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 = 1998 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 = 1999 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 = 2000 It is not necessary to fill in the operation symbol between every two numbers. The number without operation symbol in the middle is regarded as an integer
18. Add operation sign or bracket to make equation hold. 5 () 5 () 5 () 5 = 28 () 8 () 8 () 8 = 3 I love Beijing Olympic Games Different words mean different numbers. I love Beijing Olympics = ()
19. Urgent need for English diary 3 20 words
20. Ask for seven English diaries (one about 100 words)