Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
hey i am going a sreadsheet for heat loss calcs but can any one tell me how
to multiply by the power example: .05^1.3 i tried doing tht in the cells but it doesnt seem to work and help would be great as i dont want to do them all by hand will take ages thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
Put the = sign in front:
=0.05^1.3 will display 0.020355 -- Gary''s Student - gsnu200815 "milo" wrote: hey i am going a sreadsheet for heat loss calcs but can any one tell me how to multiply by the power example: .05^1.3 i tried doing tht in the cells but it doesnt seem to work and help would be great as i dont want to do them all by hand will take ages thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
"Gary''s Student" wrote: Put the = sign in front: =0.05^1.3 will display 0.020355 -- Gary''s Student - gsnu200815 "milo" wrote: hey i am going a sreadsheet for heat loss calcs but can any one tell me how to multiply by the power example: .05^1.3 i tried doing tht in the cells but it doesnt seem to work and help would be great as i dont want to do them all by hand will take ages thanks t thanks for tha |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
Hi Milo
=POWER(n,power) eg =POWER(4,2) outputs 16 Best rgds Chris Lav "milo" wrote in message ... hey i am going a sreadsheet for heat loss calcs but can any one tell me how to multiply by the power example: .05^1.3 i tried doing tht in the cells but it doesnt seem to work and help would be great as i dont want to do them all by hand will take ages thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |