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
|