Simple IF Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Doing online course, but cannot get this part. It is to be entered in col.F2(CPP) and is dependent on col E2(Gross ss Pay
 
Hi Bonnie!

Here's a simple example:

=IF(E2<1000,E2*10%,IF(E2<5000,E2*20%,E2*30%))

The IF function returns one value specified condition evaluates to
TRUE and another value if it evaluates to FALSE

It has the syntax:

=IF(logical_test,value_if_true,value_if_false)

The logical test should be capable of standing alone and returning
TRUE or FALSE

EG

=E2<1000
Returns TRUE if E2<1000 or FALSE if E2>=1000

But send more details if you still have problems.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Bonnie V.C. said:
Doing online course, but cannot get this part. It is to be entered
Click to expand...
in col.F2(CPP) and is dependent on col E2(Gross ss Pay .
 
Back
Top