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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Functions

Functions

ResolvedVersion 2007

Tue 14 Oct 2008, 15:09 Delegate Kayleigh said...

Kayleigh has attended:
Excel Intermediate course

Functions

how do change if functions in relation to dates?

for example how do i highlight late payments in a spreadsheet using the 'IF' function.

Thu 30 Oct 2008, 13:33 Trainer Amanda said...

RE: functions

Hello Kayleigh

Thank you for your question and welcome to the forum.

I have attached a spreadsheet as an example of how you would use the IF function to show if an invoice was overdue for payment, and then how you can use conditional formatting to highlight cases where the invoice is overdue.

Kind regards
Amanda

Attached files...

invoice overdue if.xls

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Functions

Functions

RE: functions

Attached files...

Excel articles

Excel tip:

Generate randon numbers