Re: [ExcelVBA] Excel formula

 



Well, no, it doesn't make more sense ...

 

> "If the column look up is less than 250 OR less than 500 ..."

 

This doesn't make any more sense than the "and".  If it is less than 250, it is clearly also less than 500.

 

Please explain the task, not specific tests like this.

 

> "I achieved this with series of nested ifs ..."

 

Which are???  Please always post what you've already done.

 

Perhaps you should upload your workbook to the files area.

Regards, Dave S
 

----- Original Message -----

From: Prasanna Kumar pkj7461@yahoo.com [ExcelVBA]

To: ExcelVBA@yahoogroups.com

Sent: Tuesday, December 29, 2015 3:47 AM

Subject: Re: [ExcelVBA] Excel formula

Hi David,

sorry, should have been more clear...If the column look up is less than 250 OR less than 500 and row lookup is less than 500, then the formula should pick factor 1...I achieved this with series of nested ifs but wanted to see if there is any other efficient way of doing it...

this is more of insurance data where I am comparing the limits to add the factor...

hope it makes sense. please let me know if you want me to elaborate it further...thanks!

On Saturday, December 26, 2015 11:24 PM, "'David Smart' smartware.consulting@gmail.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:

 



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 -----

From: Prasanna Kumar pkj7461@yahoo.com [ExcelVBA]

To: ExcelVBA@yahoogroups.com

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.6176 / Virus Database: 4489/11276 - Release Date: 12/29/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 (4)

----------------------------------
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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___