is_utf8:0,
 
Search : in
By :

Generate discount calculation sheet in Excel

Last answer on Oct 31, 2009 1:07:20 am GMT Caramel, on Oct 30, 2009 9:38:33 pm GMT 
 Report this message to moderators

Hello,

I am looking for help for coding in Excel. I have a customer buying more than 50 books which will receive a discount of 35%. If less than 50 books then a discount of 20% will be given. How do I calculate this in Excel?

Thanks

Configuration: Windows XP
Firefox 3.0.15

Best answers for « generate discount calculation sheet in Excel » in :
How to convert a numeric value into english Word? ShowHow to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Create an Attendance Report with Excel sheet ShowCreate an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

1

 venkat1926, on Oct 31, 2009 1:07:20 am GMT

Suppose A2 is the name of the book B2 is the notional price of the book and C2 is the no. of books purchased, D2 is the discounted price (row 1 is for column headins)
then type this formula in D2
=if(c2>50,B2*0.65,B2*0.80)

you can copy D2 down for other books. easy ways of copying D2 is to take the curor to the right bottom of D2 and it turns into + and click this +.(provided there is not gap row)

   
Reply to venkat1926
Ask your question Reply
They need your help