Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting
Resolved · Low Priority · Version 2007
Aleisha has attended:
Excel Intermediate course
What can you use the IF function button for?
Hi Aleisha
The IF function is a Decision making function
It allows you to enter a criteria and then create expressions that are run if true or false eg
You want the system to give ten points in cell C3 to all values greater than 500 in cell B3. So:
IF (Criteria, ValueIfTrue, ValueIfFalse)
IF(B3>500, 10,0)
Hope this helps
Carlos
Tue 3 Feb 2009: Automatically marked as resolved.
|
|
Excel tip:Create Charts with One keystrokeCreate a graph with one click |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
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
We'll call during UK business hours
Server loaded in 0.07 secs.
