<div>
There you go you can use this if formula...which will do what you want...<br />
lets say you have value in a1 then...<br />
=if(a1=&lt;2000000,a1*.5,if(a<wbr />nd(a1&gt;2000<wbr />000,a1=&lt;25<wbr />00000),a1*<wbr />.6,a1*65))<wbr /><br />
Saurabh...<br />

</div>


There you go you can use this if formula...which will do what you want...
lets say you have value in a1 then...
=if(a1=<2000000,a1*.5,if(and(a1>2000000,a1=<2500000),a1*.6,a1*65))
Saurabh...


<div>
Thanks both of you that worked great!
</div>


<div>
Any particular reason for not splitting the points equally..if both the suggestions work for you..??
</div>


Any particular reason for not splitting the points equally..if both the suggestions work for you..??

<div>
Sorry, I posted a little too quickly. I can see that Barry's formula is better than mine and that is why you selected it
</div>


Sorry, I posted a little too quickly. I can see that Barry's formula is better than mine and that is why you selected it

<div>
Actualy it had not occurred to me that I could split the points, I would have done so if I had thought about it, I will keep it in mind from now on. &nbsp;Thanks. 
</div>


Actualy it had not occurred to me that I could split the points, I would have done so if I had thought about it, I will keep it in mind from now on.  Thanks.

<div>
<div class="content wysiwyg-content">
I am trying to create a formula that allows me to populate a cell with one of three options. Effectively I'm trying to multiply one cell (dollar amount of a particular sale) on the worksheet by .5 if a different cell (the total of all sales for the month) is less than $2,000,000 or by .6 if between 2m and 2.5m or by .65 if over 2.5m. &nbsp;A normal if formula doesn't give me enough options and I've never done any VB programing. Any ideas?
</div>
</div>


I am trying to create a formula that allows me to populate a cell with one of three options. Effectively I'm trying to multiply one cell (dollar amount of a particular sale) on the worksheet by .5 if a different cell (the total of all sales for the month) is less than $2,000,000 or by .6 if between 2m and 2.5m or by .65 if over 2.5m.  A normal if formula doesn't give me enough options and I've never done any VB programing. Any ideas?

create a formula that allows three options (if 1 then 2 or if 3 then 4 or if 5 then 6)

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.