what if functions

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

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » What If functions

What If functions

resolvedResolved · Low Priority · Version 365

oluwatoyin has attended:
Excel Intermediate course

What If functions

none

RE: What If functions

Hi Oluwatoyin

Thank you for using the forum to ask a question.
Looks like you left this comment while completing feedback.

Do return to this area when you have a question and the learning team will be happy to assist you with queries connected to topics you covered during the course

Kind regards

Richard

STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: What If functions

I would like to create an excel sheet to track sick leave that is annually rolling.

So if i took 5 days in March and I get 10 days per year, what excel functions do I need to use to track when I get those 5 days back?

I think it's an 'If' function.

If Amy -5 days in march 2022 then add 5 days in March 2023?

I would appreciate your insight.


 

Excel articles

Please browse our web site to find out more about
application development excel and other training courses.

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.