Formula - Currency

There are certain formulas that you can use that will result in a a certain type of field. A formula - currency field will allow you to create a formula and have the end result formatted as a currency field. Equally, a Formula - Numeric will allow you to create a formula and have the end result formatted as a numeric field. The end result must be a number, otherwise the field will not pull the information. This guide will provide you with some commonly used formulas

Note: You can copy and paste any one of these formulas into the formula box. Drag and drop your numeric fields to replace "field". You can also put numeric values in place of fields.

• Sum
  The sum function will add all of the fields that you have inside of the formula:
  
  SUM()
  SUM(¦revenue¦)
  
  
• Product
  
  The product function will multiply all of the field values inside the formula:
  
  PRODUCT(field,field)
  PRODUCT(¦price¦,¦quantity¦)
  
  
• Sum Product
  
  The sum product function will return the sum the product of the fields in the formula:
  
  SUMPRODUCT(field,field)
  SUMPRODUCT(¦revenue1¦,¦revenue2¦)
  
  
• Average
  
  The average function will return the average of the values of the fields in the formula:
  
  AVERAGE(field,field)
  AVERAGE(¦price¦)
  
  
• Minimum
  
  The min function will return the smallest value from the set of fields specified:
  
  MIN(field,field)
  MIN(¦revenue¦)
  
  
• Maximum
  
  The max function will return the largest value from the set of field specified:
  
  MAX(field,field)
  MAX(¦revenue¦)
  
  
• Exponent
  
  Calculates the result of a number raised to a power:
  
  POWER(number,power)
  POWER(¦number¦,¦power¦)
  
  
• Future Value
  
  The future value function will return the future value of an investment based on periodic, constant payments and a constant interest rate:
  
  FV(rate,nper,pmt,pv,type)
  FV(¦rate¦,¦#ofpayments¦,¦payment¦,¦price¦,¦paymentdue¦)
  
  rate = the interest rate per period. nper = number of payments in each period. pmt = payment made each period. pv = present value or what the series of payments is worth now. type= 0 if payments are at the end of the period, 1 if payments are at the beginning of the period.
  
  
• Interest Rate
  
  
  The interest rate formula will return the interest rate for a fully invested security.
  
  INTRATE(settlement,maturity,investment,redemption,basis)
  INTRATE(¦settledate¦,¦maturity¦,¦investment¦,¦redemption¦,¦basis¦)
  
  settlement= security's settlement date. Maturity= the security's maturity date. investment= the amount invested in the security. Redemption= the amount to be received at maturity. Basis= type of day count basis to use. 0= US 30/360. 1= Actual/actual. 2= actual/360. 3= Actual/365. 4= European 30/360.
  
  
• Payment
  
  Calculates the value of a loan payment with constant payments and constant interest rate:
  
  PMT(rate,nper,pv,fv,type)
  PMT(¦rate¦,¦#ofpmts¦,¦price¦)
  
  Rate= interest rate. Nper= number of payments. Pv= the present value or current price. Fv= The future value, if left blank then assumed to be 0. Type= 1 or 0 indicates when payments are due. 0 or omitted at the end of the period.
  
  
• Net Present Value
  
  Calculates the net present value of a series of cash flows based on a discount rate:
  
  NPV(rate,value1,value2...)
  NPV(¦rate¦,¦investment¦,¦Revenue1¦,¦Revenue2¦) Rate= discount rate. Value= the values of the cash flows.
  
  
• Random Number
  
  Returns a random number in between 0 and 1:
  
  RAND()
  
  
• Rounding
  
  Rounds a number to a specific number of digits:
  
  ROUND(number,num_digits)
  ROUND(¦grossmargin¦,2)
  
  Number= number to be rounded. Num_digits= the number of digits you want the number rounded to.