If formula using 2 or more columns
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! |
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! |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com