How do I get the same result in Excel as on Calculator for 100*10.

P

ProfDocs

What is the correct syntax for a formula to calculate the percentage of a
number then add a percentage of the result to the result? For example,
100*50%+50%. Done on a calculator, the result is 75, the answer I expect.
Calculated in Excel, the result is 50.5. What am I doing wrong?

The formula as I input it to the spreadsheet is =Product(100*50%+50%). I
then press Ctrl+Shift+Enter as suggested for an array.

Can anyone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I express the following calculation. 3
Calculate Percentage of Total for Category 6
How to get a value from 1 table to a 2nd. 15
Statistics question - How many painters do I need to feed? 0
Formula Query 9
How to calculate form field 1
How do I calculate a weighted average and exclude the empthy cells 2
Calculate score from Scale 5

Top