Write a formula function for different senarios

Joined
Oct 15, 2011
Messages
1
Reaction score
0
I have been searching quite a long for a formula that can use fit for my problem here. Hope anyone can write a formula to meet my senarios here....:(
i need excel to give me a result IF:-
a salesman is below target for a consecutive 2 months will result in 'warning' category
third month, IF still below target will result in 'consultation' category, OR if is above target will result remain in 'warning' category.
forth month, IFstill below target will result in 'see boss' category, OR if above target will result 'normal' category, out of warning category.
Others will keep monitoring based on the basic 2 months consecutive senario.
 
Joined
Dec 29, 2011
Messages
6
Reaction score
0
What language/program/application are you using? I'm going to assume Excel since you reference formula, but we can't be sure.... ?

If it is Excel, search for Conditional Formatting. Otherwise, post back what you're trying in what program.
 

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

IF Function 6
Excel Conditional formula for different scenarios 0
formula for transpose 1
A or B 2
wrong format for month in cell 4
Max no. of times a text repeated 3
Formula for variable-height group average 3
Please help 2

Top