Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|