help Calculating Savings

  • Thread starter Thread starter Kim Jackson
  • Start date Start date
K

Kim Jackson

I need help with a formula to do a calculation on a
form..
I have [Cst_Saving], [YrSaving]. What I need to do is
have a formula that will take [Cst_Saving]* months left
in year to equal [YrSaving]
Ex.
[Cst_Saving] * (current month being Nov) 150 * 2 =
300 [YrSaving]
[Cst_Saving] * (current month being Feb) 150 * 11 =
1650 [YrSaving]

Thanks for the help
 
I need help with a formula to do a calculation on a
form..
I have [Cst_Saving], [YrSaving]. What I need to do is
have a formula that will take [Cst_Saving]* months left
in year to equal [YrSaving]
Ex.
[Cst_Saving] * (current month being Nov) 150 * 2 =
300 [YrSaving]
[Cst_Saving] * (current month being Feb) 150 * 11 =
1650 [YrSaving]

Thanks for the help
Click to expand...

Try

[Cst_Saving] * (13 - Month(Date())
 
Back
Top