functions

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Functions

resolvedResolved · Low Priority · Version 2007

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.

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


Server loaded in 0.11 secs.