More Excel Help Needed
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
More Excel Help Needed
I need someone who is really good at excel to help me with some advanced logic.
Who here is good at excel? If you are please let me know so I can bounce a couple of questions off of you. I would really appreciate it.
-Brian
Who here is good at excel? If you are please let me know so I can bounce a couple of questions off of you. I would really appreciate it.
-Brian
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
i need it to be able to pull from different fields. ie:
I need it to calculate the following. Lets say the value someone enters in a field is $52,000. I need it to have logic that will be able to determin what interest rate the person would get from a chart.
So if field ___ = 0-5,000 then multiply the field by x1
if ___ = 5,0001 -10,000 then multiply the field by x2
if ___ = 10,0001 -20,000 then multiply the field by x3
and so on.
I need it to calculate the following. Lets say the value someone enters in a field is $52,000. I need it to have logic that will be able to determin what interest rate the person would get from a chart.
So if field ___ = 0-5,000 then multiply the field by x1
if ___ = 5,0001 -10,000 then multiply the field by x2
if ___ = 10,0001 -20,000 then multiply the field by x3
and so on.
BOOM goes the dynamite!
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
Originally Posted by RB
IF(B2<=5000,B2*x1,IF(B2>5000<=10000,B2*x2,IF(B2>10 000<=20000,B2*x3)))
Where B2= where you're drawing the actual data from.
Where B2= where you're drawing the actual data from.