|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-09-2006, 08:43 PM
|
|||
|
|||
|
Is this possible?
Hello,
I was wondering if anyone can assist me with a formula. This is what I need: C19 is where you enter the inches C20 adds the charge The formula to go into C20 needs to be this: If the number in C19 is 01" through 12" is entered, add $75. If 13" thorugh 24" is entered, add $175, if 25" through 36" is entered, then add $275, otherwise (or anything else), enter $0 to C20.  Is this even possible?.... I would really appreciate your help. Bella 
|
|
#2
08-10-2006, 09:19 AM
|
|||
|
|||
|
Is this what you mean?
=IF(AND(1<=C19,C19<=12),75,IF(AND(13<=C19,C19<=24),175,IF(AND(25<=C19,C19<=36),275,0)))
|
|
#4
11-15-2006, 07:23 AM
|
||||
|
||||
|
Whether it solved it, we don't know, but it works.
But it would still be nice the here from mbdbiz
__________________
oldchippy -------------  Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
 |
| 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
