Previous Topic Next Topic

If stement with true result

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

Réponse 1 / 1
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
1 Jun 2009 à 07:11
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