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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
what if functions

ResolvedVersion 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 tip:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.