Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel consultants - formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Formulas

excel consultants - Formulas

ResolvedVersion Standard

George has attended:
Excel Intermediate course

Formulas

What formula does one need to use to calculate for instance 'future sales' based upon current sales data?

Thanks

RE: Formulas

Hi George,

Thanks for your question.

The answer to your question really depends on what calculation you want to do to return the future sales! For example, if you would predict a 5% return next year your formula could be =A1*5% given that A1 contains your present sales and the formula (A1*5%) is contained in a different cell.

If you let me know what calculations you are looking at I could look into the options.

Hope that helps

Tracy

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.