guidx
asked on
If and between-values in Numbers for iWork or in Excel.
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=CHOOSE(MIN(A1-B1,3),100,5
Where A1 is x and B1 is y.
Kevin