Login problems? Try a hard refresh on the page (CTRL + R)
More info

Call +27 (0) 81 044 2984
info@auditexcel.co.za

Next MS Excel Training Dates

2020: JHB (20-24 Apr, 14-15 May) CT (6-8 July)

View Calendar

What is your MS Excel Skill Level?

Take Our Test

What are you looking for?

Search the Site

Home
About Us
Consulting
- MS Excel Consulting
- Client Reviews
Live Training
Online Excel Courses
Excel Tips, Tools & Videos
Online Shop
- Online Courses Shop
- Excel Tools/ Add Ins Shop
Contact Us

IF Examples- staff ratings, account printouts

Please purchase the course before starting the lesson.

IF Examples- staff ratings, account printouts

Back to: Excel for Human Resource and Payroll Personnel > Function and Formula Basics

Select Your Currency

Excel for Human Resource and Payroll Personnel

Previous
Next

Function and Formula Basics
Tip- Opening Frequent files
Function Wizard- the Excel cheat tool
Track where a formula comes from
Formula Auditing Examples
Referring to a fixed cell e.g. commision rate
Using the F4 shortcut for $ signs
$A$1 Examples- comm payouts and more
The basic “IF” function
IF Examples- staff ratings, account printouts

Training Courses

Online Training
Live Training
Skills Assessment
Presenters

Useful Links

Video Tutorials
Blog & Excel Tips
Online Shop
About AuditExcel

Give us a call +27 (0) 81 044 2984
Email: info@auditexcel.co.za

All content copyright AuditExcel 2020

Home
Sitemap
Privacy Policy
Terms & Conditions
Support
Email Us