Sabtu, 26 Desember 2015

Re: [ExcelVBA] Excel formula


Sorry, makes no sense to me.  E.g. "if the column look up is less than 250 and less than 500" is meaningless
Please describe what you are trying to do, rather than talking about values.
Please also show any formulas you already have.

Regards, Dave S
----- Original Message -----
Sent: Saturday, December 26, 2015 1:15 PM
Subject: [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

No virus found in this message.
Checked by AVG -
Version: 2016.0.7303 / Virus Database: 4489/11263 - Release Date: 12/26/15


Posted by: "David Smart" <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: 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