How to create a formula in a cell in excel?

Asked By james andrew 0 points N/A Posted on - 11/04/2011

 

Hello!

I have a Microsoft Excel document used to calculate percentage options:

– For items that cost $20 or less I charge 20% but minimum $3

– For items that cost more than $20 but less than $35 I charge 15% but minimum $5

– For items that cost more than $35 I charge 10%, but minimum $8.

I’m looking for a formula to use for both the cell for the amount and the cell for the result, without using a third cell for the percentage.

Does anyone know how to do this? 

• Status: Open
• Question Views: 1012
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Jackman

Go To Solution

Best Answer

Best Answer

Answered By Jackman 0 points N/A #105269

How to create a formula in a cell in excel?

Hi James,

Before starting your calculations of percentage in Excel you have to review your memory on how to calculate percentage normally, now that you have review you are ready for the calculation.

Determine what percentage your price from cell B is to the value on cell C. The formula you will use is =(B2/B$20)*100 this will help you get the percentages if you want to calculate for 35% then replace the 20 above with 35 and 15 respectively. After you place it in the cell C2 you can now fill it to all your required cells and this is the main benefit of excel. I am sure that this will work for you in your calculation.

About Jackman

Questions
4

Answers
159

Best Answers
47

• Vote Up 0 Vote Down

• Posted on - 11/04/2011
• Question Category: MS Excel

Answered By Mahesh Babu 20 points N/A #105270

How to create a formula in a cell in excel?

Hallo James,

You can use formulas in excel by accessing the fx function. And in this case you will have to use the IF function to set the conditions for the price of goods.

• With excel document opened, look for the fx function and click it. But first place the cursor in the cell where you want the rsult to appear.
• Click on fx, a window will open.
• Look for if among the listed functions, and the click on it and then click OK.
• Enter the formula in the function arguments window. Ensure the logical tests and the values if true or false are declared properly, and the click OK.
• See images below for guidance.

__

Regards
Mahesh Babu

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/04/2011
• Question Category: MS Excel