cmeredith1973
New Member
- Joined
- Apr 8, 2019
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi - I am trying to have an if(or(and syntax) and am trying to solve this true or false statement. I wanted to ask for the forum for some help, thank you in advance.
I have 2 col's, B6 which either equals 0, 1 or more than 1.
Col J, is has values going from 0-100% or more.
=(IF(B6=1,SUM(J:J),IF(AND(B6>1,SUM(J:J>95%)),"total over qty",SUM(J:J))))
I wanted to ask how I can get the syntax to flow. It works but never equals the true statement of "total over qty", it always sums the final j col.
What I am trying to is measure a table of products. when theres 1 in b6, i just want it to sum col J. when its more than 1, i want to to say "full" when col J is 95% or higher. When its less than 95%, i want it to sum col J.
I have 2 col's, B6 which either equals 0, 1 or more than 1.
Col J, is has values going from 0-100% or more.
=(IF(B6=1,SUM(J:J),IF(AND(B6>1,SUM(J:J>95%)),"total over qty",SUM(J:J))))
I wanted to ask how I can get the syntax to flow. It works but never equals the true statement of "total over qty", it always sums the final j col.
What I am trying to is measure a table of products. when theres 1 in b6, i just want it to sum col J. when its more than 1, i want to to say "full" when col J is 95% or higher. When its less than 95%, i want it to sum col J.