Jump to content

formulas


This topic is 8513 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have a question regarding creating a formula. I need to create an average formula in one field D. It needs to accommodate the following conditions:

If there is a score in field A, field B and Field C then divide the sum of these three by 3

If there is a score in field A and field B then divide the sum of these by 2

If there is a score in Field B and C then divide the sum of these by 2

If there is a score in Field A and C then divide the sum of these by 2

If there is a score in field A then divide by 1

If there is a score in Field B then divide by 1

If there is a score in Field C then divide by 1

Thank you to anyone out there who can help me with this problem.

Link to comment
Share on other sites

Sounds like another job for a Case Statement :-)

This should accomplish what you're trying to do...

Case(

not IsEmpty(Test A) and not IsEmpty(Test : and not IsEmpty(Test C), (Test A + Test B + Test C) / 3,

not IsEmpty(Test A) and not IsEmpty(Test B) and IsEmpty(Test C), (Test A + Test B) / 2,

not IsEmpty(Test A) and IsEmpty(Test B) and not IsEmpty(Test C), (Test A + Test C) / 2,

IsEmpty(Test A) and not IsEmpty(Test B) and not IsEmpty(Test C), (Test B + Test C) / 2,

not IsEmpty(Test A) and IsEmpty(Test B) and IsEmpty(Test C), Test A / 1,

IsEmpty(Test A) and not IsEmpty(Test B) and IsEmpty(Test C), Test B / 1,

IsEmpty(Test A) and IsEmpty(Test B) and not IsEmpty(Test C), Test C / 1, 0)

Hope that's helpful...

Later,

Paul :-)

Link to comment
Share on other sites

This topic is 8513 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.