This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: =tax(C7, rate) where "rate" is a named range Function Details Example 1: Begin Function tax (taxableAmount is money, taxRate is decimal) returns money tax = taxableAmount * taxRate End Function Example 2: Begin Function tax2 (taxableAmount is money, taxRate is decimal, taxable is Boolean) returns money If taxable = TRUE then tax2 = taxableAmount * taxRate Else tax2 = 0 End If End Function Example 3: Begin Function tax3 (taxableAmount is money, stateRate is decimal, cityRate is decimal, taxable is Boolean, inCity is Boolean) returns money If taxable = TRUE then tax3 = taxableAmount * stateRate If inCity = TRUE then tax3 = tax + taxableAmount * cityRate End If Else tax3 = 0 End If End Function...
View Full Document
This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.