Need HELP with NESTED IF
 

codewalker wrote:
=if (g69=h69,d73*(g69-j61)/100), If (g69<h69 And G69=(h69-j61),
D72*(g69-j61)/100)

This Is Just For The First Two Of 5 Pay Levels - But Won't Work After
The Second If Is Ran. The First If By Itself Runs Fine.

G69 = Sales
H69 = Goal
J61 = ((h69-h61)/5)
D73 = .15
D72 = .10

Any Assistance Would Be Greatly Appreciated!


Looks like your brackets are messed up

=if (g69=h69,d73*(g69-j61)/100), If (g69<h69 And G69=h69-j61),
D72*(g69-j61)/100))

etc.

HTH

RP