An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert whose answer got voted for 20 times.
An expert who has answered 20 questions.
Re: multiply a value by a minimum amount
You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1
after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
I assume that you are creating a pro-forma for others to use. Very simply, you could offer a cell that asks the user to nominate the applicable tax rate for their tax jurisdiction, or, if you know (or assume the value), place that into a cell then multiply the taxable amount by 1+the tax rate, ie I buy shoes for $4 and have a 10% tax rate. Multiply the price of the shoe by 1.04 and you have the final price, inclusive of taxes.
Usually all fees and charges are applied before the taxes are calculated., but check your local tax rules because some government levied charges may not be taxable.
Maybe this is what you need: =IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4)))))) this is called "nested". You can put nested if function maximum 7. (for more than 7, we should make another "trick") if you put toilet in A1 then come the value B1*2 if you put bread in A1 then come the value B1*3 if you put star in A1 then come the value B1*4 Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)