Thread: More Excel Help Needed
View Single Post
Old Aug 16, 2004 | 07:32 AM
  #7  
RB's Avatar
RB
snitches get stitches
 
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
Default
IF(B2<=5000,B2*x1,IF(B2>5000<=10000,B2*x2,IF(B2>10 000<=20000,B2*x3)))


Where B2= where you're drawing the actual data from.
Reply
0