formulas

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 » Formulas

Formulas

resolvedResolved · Low Priority · Version Standard

Jonathan has attended:
Excel Intermediate course
Excel Advanced course

Formulas

What is the purpose of IF statements?

RE: Formulas

Say you have a list of data for a sales department. If the value of the sale was 1-15 then you want the value in the column to say 'Small Sale', value is 16-30 then 'medium sale', value is >31 then 'large sale' then this could be achieved by using an if statement. One example of many.


 

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


Server loaded in 0.08 secs.