FN-GM Posted September 22, 2017 Posted September 22, 2017 Hello, I want a Forumla to auto populate in a column when a new row is added. I read that an Array Formula in conjunction with my normal formula can do this. However it doesn't seem to work. This is my forumla - =ArrayFormula(GTE(C2, 80)) The original formula will display True if the data in C2 is equal to or greater than 80. If not it will display fale. Does anyone have any tips please? Thanks
FN-GM Posted September 22, 2017 Author Posted September 22, 2017 Got it! =ArrayFormula(GTE(C2:C, 80))
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now