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?
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?