If stement with true result

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
I would like to create an IF statement that will select the nearest match from a row of numbers.
For example:

The stock i have sold per month =350, my new buying quantities are 300, 500, 1000, 1500, 2000. How do I construct a statenment to select the one greater than my 350?

Thanks Steve

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi

Use the formula =IF(stock>1500,2000,IF(stock>1000,1500,IF(stock>500,1000,IF(stock>300,500,300)))) and replace the 'stock' in the formula with suitable cell address