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

Hi,

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!

lookup(<250/<500)
<500 1
> = 1000 1.5
>=500 and < 1000 2

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

__._,_.___

Posted by: "David Smart" <smartware.consulting@gmail.com>
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: 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:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar