help Calculating Savings

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
 
J

John Vinson

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())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form Calucation 2
Display weeks from a Milestone 0
A couple questions BEFORE using Office 365 0
Use excel to calculate an expiration date 1
Keep First Letters, with exceptions 0
Help showing active months between two dates 5
Percentage of month passed formula 1
How to dynamically add up varying # of cells base on a value 6

Top