nonprogrammer
Technical User
Hello,
I am having a horrible time with 0ne of my formulas
it looks something like this
A B C D E F G H I J K L M N O P
1
2
3
4
5
in B1 I enter a value then C1 is a description D1 is a value that will be added or substracted from B1
E1 =B1-D1 F1 =B1+D1 then G1 through N1 are values that will be compared to E1 and F1 Here is wher my problem begins O1 should check if G1:N1 are less than E1 or if G1:N1 greater than F1 write "Yes" Then P1 if G1:N1 is greater than E1 and G1:N1 is less than F1 write "NO"
Please help with this I am a bit desperate I have been working on this for the past couple of days and is driving me a bit crazy
thank you!
I am having a horrible time with 0ne of my formulas
it looks something like this
A B C D E F G H I J K L M N O P
1
2
3
4
5
in B1 I enter a value then C1 is a description D1 is a value that will be added or substracted from B1
E1 =B1-D1 F1 =B1+D1 then G1 through N1 are values that will be compared to E1 and F1 Here is wher my problem begins O1 should check if G1:N1 are less than E1 or if G1:N1 greater than F1 write "Yes" Then P1 if G1:N1 is greater than E1 and G1:N1 is less than F1 write "NO"
Please help with this I am a bit desperate I have been working on this for the past couple of days and is driving me a bit crazy
thank you!