If formula using 2 or more columns
=IF(AND(A1=B1,A1<=C1),D1,"do something else")
--
Regards,
Peo Sjoblom
(No private emails please)
"Wendy - Payroll" wrote in message
...
I am trying to create a formula using a table. Using the information
below,
I want to find if A1 is greater than or equal to B1 and less than or equal
to
C1, use D1.
A B C D
15450 (1) 15001 16000 700
(2) 16001 17000 750
(3) 17001 18000 800
The table is on another tab, but I know how to select those cells. I
don't
know how to combine using both columns B and C. To make it trickier, the
table has about 40 rows that need to be in the formula. I kind of
remember
doing something like this a long time ago using a conditional table, but I
can't remember what it's called.
Any help would be greatly appreciated!
|