I'm hoping that someone out here can help me with my little problem. I need to create a formula that will allow me to identify where a figure in cell A1 when compared to a figure in cell A2 is anywhere between 5% and 10% difference either + or -. I know it sounds messy but that was the best written description I could come up with.
Thanks in anticipation of some much needed help and/or advice.
I think the above formula would work.it uses a nested "if" statement. It first uses an "and" function to check that positive value lies between 5 and 10 percent. if that fails it then checks for a negative. If it finds one or the other it returns a result of true if not false. You can change the true and false statement to what ever you want. If you want text be sure to use quotation marks