| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
