|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
11-02-2006, 11:25 AM
|
|||
|
|||
|
If Nested?
I need to write a forumla that calculates the following:
- if the value of cell B6 is greater than 0 but less than 1,000 = 2.6 - if the value of cell B6 is greater than 1,000 but less than 2,000 = 2.4 - if the value of cell B6 is greater than 2,000 but less than 5,000 = 2.0 If you can give me help in writing this formula, it will be greatly appreciated. Thank you 
|
|
#2
11-02-2006, 12:11 PM
|
||||
|
||||
Quote:
Try this, =IF(AND(A1<1000,A1>0),2.6)+IF(AND(A1<2000,A1>1000),2.4)+IF(AND(A1<5000,A1>2000),2) oldchippy 
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
