How to create a formula in a cell in excel?

Asked By 0 points N/A Posted on -
qa-featured

 

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? 

SHARE
Best Answer by Jackman
Best Answer
Best Answer
Answered By 0 points N/A #105269

How to create a formula in a cell in excel?

qa-featured

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.

Answered By 20 points N/A #105270

How to create a formula in a cell in excel?

qa-featured

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

Related Questions