Hi I have a question about how to do something in Numbers in iWork and or in Excel. I want to make a cell do this:
If x - Y = between 0-4 then return 100. If x - y = between 5-9 then return 50. If not any of those return 0.
Is it possible to so something like that in numbers or in Excel?