Thread: Excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MAK MAK is offline
external usenet poster
 
Posts: 20
Default Excel formula

What is the following formula trying to do? What do the functions mean, and
the ^ symbol?

=IF(ISNUMBER((1+IRR($F$47:BA47,0.01))^12-1),(1+IRR($F$47:BA47,0.01))^12-1,"n/a")