Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF Function

IF Function

ResolvedVersion 2003

Wed 24 Jun 2009, 14:09 Delegate Kevin said...

Kevin has attended:
Excel Intermediate course
Excel Intermediate course
Excel Advanced course

IF Function

I am linking an HR spreadsheet to a 3 year Financial P & L forecast which contains the line salaries.

I have been asked to reduce all the basic salaries by 10% for each employee.

How do I do this automatically?

Wed 24 Jun 2009, 16:33 Trainer Amanda said...

RE: IF Function

Hello Kevin

Thank you for your question and welcome to the forum.

To reduce a value by 10%:
=value-value*10%

or
=value*0.9

Kind regards
Amanda

Wed 1 Jul 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

IF Function

IF Function

RE: IF Function

Excel articles

Excel tip:

Hiding and unhiding rows using the keyboard