Forum Discussion
IF between 10 and 20, get data from other tab/sheet
I want to auto populate a cell from another sheet depending on a range of numbers. Example: The ranges would be static. IF F7 is between : 10-11 R7 would be 0 12-13 R7 would be 1 14-15 R7 would...
Talk about over engineering a solution. Man I was going nuts.
However, when I tried using your formula, I get an error stating:
"The formula you typed contains an error.
- For information about fixing common formula problems...
- To get assistance in entering a function...
- If you are not trying to enter a formula..."
I also tried using "=ROUNDDOWN(F7/2-5,0)" and this works until I get to values in F7 that are >30. Anything >30 should always return 10.
I guess if you replace semicolon in Detlef_Lewin formula on comma it shall work.