View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default Please advise on length addition!

See the DOLLARDE and DOLLARFR functions in help.

=DOLLARFR(DOLLARDE(5.08,12)+DOLLARDE(7.09,12),12)

returns 13.05. These functions are part of the Analysis ToolPak
add-in, so you'll need to have that add-in loaded. Go to the
Tools menu, choose Add-Ins, and check Analysis ToolPak in the
list of available addins.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"student" wrote in message
...
Can someone advise on how to add length in Excel, for example,
I need to add
5 ft 8 in and 7 ft 9 in. I want an answer to be also in feet
and inches.

Gladly appreciate!