bulletbobb2 wrote:I tried this with an IF function, but can't get it to work.

There's an example of using

IF and

AND near the bottom of section

9. Using functions and cell ranges in

Ten concepts that every Calc user should know.

karolus wrote:Pull down

Specifically, enter the formula in the first row of column B, then

Fill the formula down the column.

bulletbobb2 wrote:Say that column A holds the numbers 1 thru 10. … if the number in column A is between 4 and 6 …

Do you mean "if the number is 4, 5, or 6"? I would say that 5 is the only number among 1,2,3,4,5,6,7,8,9,10 that is "between" 4 and 6. Choose your words carefully or you may get incorrect advice.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer

OpenOffice 3.2.0 Build 9483 on Mac OS X 10.6.8. The locale for any menus or Calc formulas in my posts is English (USA).