Nesting formulas

  • Thread starter Thread starter Ashkore
  • Start date Start date
A

Ashkore

I need to be able to create an "if" function that will populate to a couple
other "if" functions within itself.

What I'm trying to do is get one cell to look at the information entered in
another one, and if that cell gets to a certain number, to change the
equation to watch for a new number in that cell.

Example: Employee group one gets a pay raise when he hits 10, 25, and 50
sales. Employee group two gets a payraise when he hits 15, 25, and 55 sales.
How do I set a cell to say what level (1, 2, 3) the person is at currently?
 
See if the following might help. You would need to creat another formula for
each Employee group because they get raises at different levels. For Employee
Group 1
this should help

=IF(AND(D3>9,D3<25),1,IF(AND(D3>24,D3<50),2,IF(D3>49,3,"no raise")))

This is assuming that the number of sales is in cell D3, and the status
showing what level for a raise they have reached is where this formula will
reside. Hope this helps
 

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

Nest vs Hive? 10
Nested IF function 4
Nested IF that will ignore blank (empty) cells 9
Nested IF function to ignore cells with no data 1
How can I change commision % after it pass certian number 1
Nested IF - return a blank when compared cells are blank 1
how to group percentile 3
Cell doesn't appear in calculations 4

Back
Top