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.bulletbobb2 wrote:I tried this with an IF function, but can't get it to work.
Specifically, enter the formula in the first row of column B, then Fill the formula down the column.karolus wrote:Pull down
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.bulletbobb2 wrote:Say that column A holds the numbers 1 thru 10. … if the number in column A is between 4 and 6 …
Users browsing this forum: ikadi and 30 guests