Need HELP with NESTED IF

  • Thread starter Thread starter codewalker
  • Start date Start date
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!
 
try this idea
=if(g69>=h69,d73,if(g69>=(h69-j61),d72))*(g69-j61)/100
 
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: ---->
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF: Using CPEARSON Approach 3
Nest If - What am I doing wrong... 7
Limitation of Nesting of Function 3
Need help with =IF formula 7
Nested IF function 3
IF Nested Function 14
Nested If testing 3
Excel nested IF formula question 6

Back
Top