I am looking for a way to find a number that is between two numbers. I know >=, and <=, but what about between two numbers. I can't figure out a formula that follows that formula. Help!
I am looking for a way to find a number that is between two numbers. I know >=, and <=, but what about between two numbers. I can't figure out a formula that follows that formula. Help!
Not sure what you are looking for so check out this site in this website
http://www.exceltip.com/st/Counting_..._List/803.html
Dave, I didn't explain myself very well. I have a row of numbers and I am trying to calculate a selling price based on volume. If the quantity is between 1 and 25 then use one value if it is greater than 25 but less than 50 then use another number, and if greater than 50 use another. I can do the less than 25 and the greater than 50 but how do i do the between 25 and 50. I am using an 'if' formula and it works fine except for this one section?
Chris
=and(>=25,<=50)
I think you are close. Here is what I have
A B C D E
1 Quantity 1-9 10-25 25+ Total
2 21 5.25 4.75 4.25 89.25
Here is a part my E2 formula, I am trying to get E2 to automatically pick the right $ based on quantity. I know this is simple, just can't get there.
=IF(A2<10,B2*A2,IF(A2>=10???,C2*A2),IF(A2>=25,D2*A2))
Help! If there is a simpler way, let me know
Thanks
Chris
it didn't post like i drew it out. Shift all of the numbers adn letters over.
=IF(A2<10,B2*A2,IF(A2>=10???,C2*A2),IF(A2>=25,D2*A 2))
you will never reach the 3rd condition as >=10 will always be true if >=25
=IF(A2<10,B2*A2,IF(A2<25,C2*A2,IF(A2>=25,D2*A2,"")))
Perhaps
Regards
Dav
Dav, that worked like a champ, thanks
Chris
hey, i was trying to follow your idea with that if statement. this is what im trying to do.
B15=120 C15 = 54 D15=34
my next line has to show the value of b15 if it's 90 or less.
next line has to show the value of b15 if its between 90 and 180
next line has to show the value if b15 if its between 180 and 270
and the last line has to show the value of B15 if its above
what is the formula for these...i know the last one and the first one. i just need the middle two. everytime i put in the following forumla both the middles show up.
2nd row: =IF(B15<180,B15,IF(B15>90,B15,IF(B15>=90,B15,"") ))
3rd row:=IF(B16<180,B16,IF(B16>90,B16,IF(B16>=90,B16,"") ))
b15 -d15 will change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks