I would like to calculate average. If the field is blank, blank cells should not be calculated as shown in excel. How can I do that in Caspio? Also how can I add and statement like rules in Caspio?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
capsio88
Hi I am using this formula on my excel worksheet;
=IF(AND(I11<>"",I12<>"",I13<>"",I9<=3),AVERAGE(I11:I13),"") and
=IF(AND(K13<>"",K12<>"",K13<>"",I11<>"",I12<>"",I13<>"",AND(I9>3,I9<=6)),AVERAGE(I11:I13,K11:K13),"")
I would like to calculate average. If the field is blank, blank cells should not be calculated as shown in excel. How can I do that in Caspio? Also how can I add and statement like rules in Caspio?
Many thanks
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.