If Formula
I would like to create a formula that looks at four days on hand criteria and returns a value based on a band of days
Ex: if the lookup value is <=30 return "35" if the lookup value is between 36 and 40 return "25", if the lookup value is between 41 and 44 return "15" and if the lookup value is above 45 return "0" any help is most appreciated |
If Formula
Hi David,
Am Wed, 15 Oct 2014 16:41:38 +0100 schrieb Davidgberg: I would like to create a formula that looks at four days on hand criteria and returns a value based on a band of days Ex: if the lookup value is <=30 return "35" if the lookup value is between 36 and 40 return "25", if the lookup value is between 41 and 44 return "15" and if the lookup value is above 45 return "0" and what about the values between 31 and 35? Try: =VLOOKUP(A1,{0,35;36,25;41,15;45,0},2,1) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
If Formula
Hi David,
Am Wed, 15 Oct 2014 17:56:18 +0200 schrieb Claus Busch: =VLOOKUP(A1,{0,35;36,25;41,15;45,0},2,1) have a look: https://onedrive.live.com/?cid=9378A...121822A3%21326 for the workbook "David" Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com