Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chiefwidmer chiefwidmer is offline
external usenet poster
 
Posts: 4
Default Formula

I need to calc an amount dependent on the premium mode in a drop down list.
The list is monthly, quarterly, semi-annual, annual. Is there a formula that
can be used to calculate the refund amount depending on which drop down item
is selected? Here is a sample of what I am trying to do.

PREMIUM $600.00

PREMIUM MODE Monthly

# OF MONTHS DUE 7

REFUND $350.00