Need HELP with NESTED IF

C

codewalker

=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!
 
C

codewalker

what about the AND on the second if?

the second if has 2 criteria

1st - must be less than h69
2nd - must be greater than h69-j61



I tried the previous suggestion and it just returned: ---->
 
B

Bob Phillips

codewalker said:
=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!
Click to expand...
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
 
Top