Previous Topic Next Topic

If stement with true result

Closed
steve - Jun 1, 2009 at 05:08 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 1, 2009 at 07:11 AM
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
Related:

1 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 1, 2009 at 07:11 AM
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
0