Aleisha has attended:
Excel Intermediate course
Conditional formatting
What can you use the IF function button for?
RE: Conditional formatting
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