How to set excel formula alert on amount in minimum and maximum

[gc7sdu]

Hi,

how to set excel formula alert on figures reached in minimum or maximum? example sales reached near min or reach maximum target.

Thank you

 

[Cubist]

How do you envision the alert? Please provide a sample data set demonstrating what you're trying to accomplish. Add as much details as possible.

 

[gc7sdu]

How do you envision the alert? Please provide a sample data set demonstrating what you're trying to accomplish. Add as much details as possible.

let say target sales amount year 1 set minimum 5000 and maximum 12000. when certain time sale has meet at high near target like 9000 will be alert in excel "Success", when sales still at minimum level at 6000 will be "fail"

so that, min 5000- 12000 max, when sales figures at min level 5000 to 6000 as "fail" while figures come to 10000 to 12000 as "success"

Thanks

 

[Cubist]

I got the 5000 (min) and 12000(max). I don't understand where the ranges 5000-6000 and 10000-12000 come from?

 

[gc7sdu]

I got the 5000 (min) and 12000(max). I don't understand where the ranges 5000-6000 and 10000-12000 come from?

example if when i want track sales figures before year end, 5000 is min however, actual sales only achieve 6000 then within this range 5000 to 6000 is alert for fail sales target meet. in another side 10000 - 12000 is max when track sales figures has reached this range mean indicated success achieve target.

 

[Cubist]

I don't follow the logic. If you set your min target is 5000, then any sales over 5000 should be success? I suggest you manually create an example of what you want to happen else we're going in circles.

 

[gc7sdu]

I don't follow the logic. If you set your min target is 5000, then any sales over 5000 should be success? I suggest you manually create an example of what you want to happen else we're going in circles.

Hi Cubist,

when sales amount reached at the range min:5000-6000 or max 8000-10000 against actual sales F3 to alert "Poor or Excellent" in G3.

Thanks for your advise.

 

[LegendaryAxe]

If you want the alert to be just text in a cell, try this:

Book6
	A	B	C	D	E
1	Start Poor	End Poor		Start Exc.	End Exc.
2	5000	6000		8000	10000
3
4	Sales	Alert
5	3000
Sales

Cell Formulas
Range	Formula
B5	B5	=IF(AND(A5>=A2,A5<=B2),"Poor",IF(AND(A5>=D2,A5<=E2),"Excellent",""))

 

[Cubist]

Hi Cubist,

when sales amount reached at the range min:5000-6000 or max 8000-10000 against actual sales F3 to alert "Poor or Excellent" in G3.

Thanks for your advise.

What about something in between 6000-8000?

 

[gc7sdu]

What about something in between 6000-8000?

Hi Cubist,

Oh ya, you're right...can it stated as "Average"...Kindly assist. Many Thanks