The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

IF Function

Resolved · Low Priority · Version 2003

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

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?

For upcoming training course dates see: Pricing & availability

ReplyWed 24 Jun 2009, 16:33Trainer 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.

Excel articles

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Create Date Sensitive Colour Changing Cells In Excel
· Summing Up Scenarios With Excel
· A Picture Is Worth A Thousand Words (Or Numbers)
· Microsoft Office and the Small Business: Part 1 Excel

Please browse our web site to find out more about
advanced excel course and other Microsoft training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Hi

I am ready to upload my files to a remote server, but i don't know if my Internet Information Server is running. I cannot find the default Inetpub file on my computer so i'm assuming it's not?

I followed the instructions to install ISS, but it wa..

» Forum post: IIS

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions