Functions

Resolved · Low Priority · Version 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:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Functions

Functions

RE: functions

Attached files...

Excel articles

Excel tip:

Transpose text