Excel

Resolved · Medium Priority · Version 2010

Wed 4 Dec 2013, 15:57 Delegate Sarita said...

Sarita has attended:
Word Intermediate course
Excel Intermediate course
Excel Advanced course

Excel

i'd like to put a spreadsheet together where there are monies owed from several people for different music events and holidays from 2013 through to 2014.
easc has a diff payment plan.
i'd like to know how to put in formulas to know how long it will take for them all to pay off the monies owed-thanks

Fri 6 Dec 2013, 12:33 Trainer Gary said...

RE: excel

Hi Sarita

Thanks for getting in touch. I hope you enjoyed your course.

There's a few ways to lay this data out to get the result you want, but before I suggest is there any interested accumulated on these or are the amounts fixed (i.e. same payment every month) ?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 19 Dec 2013, 14:30 Trainer Cindy said...

RE: excel

Hello Sarita,

I am currently going through our forum to clear out any active questions.
Did you manage to fix the problem you asked about?

If not, please reply within five days so I can contact a trainer who can help you, otherwise this question will be marked as Resolved.

Thank you for your assistance.

Kind regards

Cindy
Microsoft Office Trainer

Fri 14 Feb 2014, 12:45 Delegate Sarita said...

RE: excel

THANK YOU FOR YOUR RESPONSE Gary.
There is no interest accrued just fixed amounts.

Thu 26 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips