11-02-2006, 12:11 PM
|
 |
"Eagle Eyed" Forum Moderator
|
|
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,087
|
|
Quote:
|
Originally Posted by meyerstc
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
|
Hi meyerstc,
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 
|