bulletbobb2 wrote:I tried this with an IF function, but can't get it to work.
There's an example of using IF
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.
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5. The locale for any menus or Calc formulas in my posts is English (USA).