View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
boba[_2_] boba[_2_] is offline
external usenet poster
 
Posts: 4
Default APY and Interest rate calculation

What is the formula to have the interest rate change based on the APY? I
have amounts between 1000 to 10,000 with Interest rate and APY. When I change
the APY I want it to calculate interest rate for all the fields with
different amounts and APY with the new interest rate based on the new APY.
How can I copy the same formula for all the other columns.