Jumat, 25 Desember 2015

[ExcelVBA] Excel formula



I thought somebody would have easier way to lookup the formula for a problem like this.
There are 3 variables(one each for <250, <500 for column lookup and <500,>=1000, >=500 and <1000 row lookup). if the column look up is less than 250 and less than 500 and row lookup is <500, the formula should pick up "1".  Pleases let me know if you need want me to further elaborate. Thanks a lot for your help!

<500 1
> = 1000 1.5
>=500 and < 1000 2


Posted by: Prasanna Kumar <pkj7461@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar