sorry for the type of post, i come from a programming background, gave up IT to train as an accountant and never had to use excel until i started this job
in some sort of pseudo programming language this is what i need
and definetly no VB as i havent gotten anywhere near that for now
IF X > 95 or < 90 then, "Error Out of Range" else "ok",
something like that, you must assume that i know what x is and i also know the average number in my head, the two numbers will just be 5 either way, a statement will be written for each grp, so all i will changes is the two numbers to fit the expected price of each product range.
just one more question, i was looking at the ABS term in the excel help to try to better understand how what you tell me works, i can see that it does but dont see how that term performs the task. If you could just say in basic terms how it does its job that would be a great help. I'm gradually learning more about excel, taking courses etc and this sort of thing would be handy thanks.
Returns the absolute value of a number. The absolute value of a number is the number without its sign."
ie Abs(number). In this case number can be a single number or the result of and expression (calculation) as in the above posts X-9.25
Whatever the value of X (greater than 92.5 or less than 92.5) ABS will always return the VALUE of the difference only (which is the same a always a PLUS/POSITVE value). Therefore, whatever the difference between X and 92.5 (+ve or -ve) it can alway be compared to +2.5 to see if the difference is greater that +2.5.