View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ADK ADK is offline
external usenet poster
 
Posts: 89
Default IF, between two numbers

How would I use and if statement based on between two numbers??

Example---

For cell A6: IF A5 is between .99 and 5, 1, 0

A5 = .25 ....so A6 is 0

A5 = 1 ......so A6 is 1

A5 = 4 .....so A6 is 1

A5 = 5 ......so A6 is 0

A5 = 6 ......so A6 is 0

----------------------------------

ALSO, have one: IF A5 is equal to 1 or between 1 and 5, but not equal or
more than 5?

Thanks