| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function the ^ sign
How do I get this to work with excel
1,03 ^ 4 - 1 = 0,1255 = 13% Tia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
=(1.03)^4-1
Format as percentage -- Kind regards, Niek Otten "beohlsson" wrote in message ups.com... How do I get this to work with excel 1,03 ^ 4 - 1 = 0,1255 = 13% Tia |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
I found another way
=SUM(B18^C18)-D18 What's the english name of the ^ sign, please Thanks a lot for your answer and time spent on my problem highly appreciated |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
It is the exponentiation operator, raising a number to a power.
Pete |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
Just leave out SUM. Not needed. The symbol is called caret.
-- Kind regards, Niek Otten "beohlsson" wrote in message ups.com... I found another way =SUM(B18^C18)-D18 What's the english name of the ^ sign, please Thanks a lot for your answer and time spent on my problem highly appreciated |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
Ok! Still can't get it
B18 = 1.03 (or 1,03) C18 = 4 D18 = 1 E20 =SUM(B18^C18)-D18 = 0,00% On my calculator the answer is 0,1255 or 13%. The numbers seems to be too small somehow for excel ;-) Help pls |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
Both =SUM(B18^C18)-D18 and =(B18^C18)-D18
give 0.12550881 How is E20 formatted? Format as General and look again -- Kind regards, Niek Otten "beohlsson" wrote in message oups.com... Ok! Still can't get it B18 = 1.03 (or 1,03) C18 = 4 D18 = 1 E20 =SUM(B18^C18)-D18 = 0,00% On my calculator the answer is 0,1255 or 13%. The numbers seems to be too small somehow for excel ;-) Help pls |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
"beohlsson" wrote in message
oups.com... Ok! Still can't get it B18 = 1.03 (or 1,03) C18 = 4 D18 = 1 E20 =SUM(B18^C18)-D18 = 0,00% On my calculator the answer is 0,1255 or 13%. The numbers seems to be too small somehow for excel ;-) Help pls It comes to 0.125509 for me. I assume that you've got at least one of the cells formatted as text, and therefore treated as zero. You need to be careful with your settings as to whether it is regarding a full stop or a comma as a decimal point. -- David Biddulph |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
E20 =SUM(B18^C18)-D18 = 0,00%
Another option: =POWER(1.03,4)-1 -- HTH. :) Dana DeLouis Windows XP, Office 2003 "beohlsson" wrote in message oups.com... Ok! Still can't get it B18 = 1.03 (or 1,03) C18 = 4 D18 = 1 E20 =SUM(B18^C18)-D18 = 0,00% On my calculator the answer is 0,1255 or 13%. The numbers seems to be too small somehow for excel ;-) Help pls |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function the ^ sign
Depending on your seperator settings (where you are in the world) =1.03^4-1 gives your required result, just format the cell as a percentage (format,cells,number,percentage 0dp) to get the result Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=508872 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change the insert function key to always be an = sign | Excel Discussion (Misc queries) | |||
| UDF help please | Excel Discussion (Misc queries) | |||
| Function to reverse the sign of a cell | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
Hybrid Mode
