HELLO,
Needs HELP as the formula I made was not addressing all cases.
Needs to make formula to alert/mention based on the level
Zohar
alert levels
-
-
-
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read [COLOR="#FF0000"]this[/COLOR] to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
-
Respected Madam AliGW,
That is not the Post I have posted Here.
I will post that URL and the Query both.https://www.excelforum.com/exc…-another.html#post5269512excel [email protected]
-
Can you explain what you are wanting in more detail.
-
Respected Sir Roy,
Needs HELP as the formula I made was not addressing all cases.
Needs to make formula to alert/mention based on the level
This is the same file that is attached in Initial post.
Zohar
-
I can't see from the example what alerts are.
-
Respected Sir Roy,
This are the alerts
Range is just for indication -it not to be included in formula
High(A) Low(B) Last(C) Range alert/Mention(In E column)
(1)8404 8390.15 8390.15 16.78 WLN▼ Last is vry low near low.Her▲also comes in range but last is low--needed to alert that level is too much low
Row 3 in file
(2)8410.35 8395.5 8410.35 16.82 WLN▲ Last is very high near high Here ▼ also comes in range but last is high--needed to alert that level is too much high
Row 9 in file
When Last reading is same as high or low Alert WLN▼(LOW) or WLN▲(HIGH) OR in 0.005%(ad not mentioned in file but I find this recently--Sorry for that)
WLN=Warning Last Near
-------------------------------------------------
Normal Case
High Low Last Range Mention(In E column)
(3)8415 8385 8398.35 16.8 LN▼ here more near is low
Row 5 in file
(4)8415.35 8384.5 8400.35 16.8 LN▲ here more near is HIGH
Row 7 in file
(4)8441 8373.15 8400.35 16.8 OR none is in range-OUT OF RANGE
Row 11 in file
Originally in the sheet which I had to keep this formula here DATA is sergegared but will manage adjusting that in formula. This is the functionality scenario.
THANK YOU
Zohar Batterywala
-
Why don't you use Conditional Formatting with Icons?
-
Respected Sir,
I had tried to use conditional formatting before but the plain file without any formatting is itself of 1.1 GB and takes 15-20 minutes for opening and 7-8 minutes to save and (conditional) formatting makes it more heavy.
I am using This file just to calculate data (as 90% of formulas needs past data of atleast 15 days).
Then this data is moved to an value only file (which is just becoming 200 MB).
Zohar Batterywala
-
You need to do something about the size of the file. Try saving as .xlsb for a start.
-
Respected,
I am SORRY
but I find the previous attachment to be not proper that I saved at last and uploaded so am uploading again
Zohar
-
Hi Zohar,
in your attachment, you've marked a couple of rows as being the problem ("issue" next to the result) ... but, in those rows, the column D area is blank. The formula refers to column D ... if I copy the formula from further up the sheet, the results are as you require.
So, is there really a problem? Or is that column D was accidentally left blank in a couple of places?
-
Respected Sir Glenn,
Yes sir it was mistake by me
Originally I had included the formula that was in D in the main formula in E
The issue is solved at this time.
Will request your help if I will need it.
The issue with me is cant find a correct answer if has done a mistake once as that type of thought do continue when reviewing the problem. In that case others perspective make a big difference for me.
THANK YOU SIR
Zohar Batterywala
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!