Function Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to return a specific number in a cell using the IF function. I would ilke it to say "If the cell value is greater than or equal to this, but less than that, cell value should be x". There are (5) different outcomes I would like to be able to reference. Every time I type in the formula, it returns as TRUE instead of as the cell I want to reference. Any ideas??

Thanks a bunch!
 
hugs883 wrote...
I am trying to return a specific number in a cell using the IF
function. I would ilke it to say "If the cell value is greater tha or
equal to this, but less than that, cell value should be x". There
are (5) different outcomes I would like to be able to reference.
Every time I type in the formula, it returns as TRUE instead of as
the cell I want to reference. Any ideas??
Click to expand...

It's almost certain either a single LOOKUP or VLOOKUP function cal
would do what you're trying to do with 5 IF calls, but it's impossibl
to be more precise since you provice no details. What's the formul
you're trying to use
 
Hugs- to best get help, you should provide your current formula, some sample
data, and what you want the formula result to be. With the info you gave
below, only a general response can be given like;

=IF(AND(A1>=5,A1<10),"x","")

"x" could be replaced with a cell ref like A1.




hugs883 said:
I am trying to return a specific number in a cell using the IF function. I
Click to expand...
would ilke it to say "If the cell value is greater than or equal to this,
but less than that, cell value should be x". There are (5) different
outcomes I would like to be able to reference. Every time I type in the
formula, it returns as TRUE instead of as the cell I want to reference. Any
ideas??
 
Pretty easy then as Harlan suggested,

if your table of monthly payments (2 columns, 5 rows) is in H1:I5, and the
value changing monthly is in A1, try

=VLOOKUP(A1,$H$1:$I$5,2)


hugs883 said:
Dave, That is the formula I am using, however, instead of returning the
Click to expand...
number I want, it returns as the words "False" or "True"
I'm trying to find the value of where it says "False" in following example:

If the value ($177,938.15) is >=($164,000) but less than ($202,883) then
Click to expand...
the monthly payment is ($1,220). If the value ($177,938.15) is >=($202,883)
but less than ($239,887) then the monthly payment is ($915)...etc... The
Value $177,938.15 changes monthly.
 
The ",2" is telling the vlookup to return the value from the 2nd column of
the table, which is the monthly payment.
 
Back
Top