View Single Post
  #1   Report Post  
AaronR AaronR is offline
Junior Member
 
Posts: 1
Unhappy AVERAGE with multiple conditions

Hello, I'm trying to calculate an average, but need to adhere to a couple conditions:
- Average must be of A and B
- A is capped at 125%
- B is capped at 163%
- A is capped at 100% if B<100%
- B is capped at 100% if A<100%

I came up with the following, but I'm just not sure how to make them play nicely together:

=AVERAGE(IF(G16125%,125%,G16),(IF(M16163%,163%,M 16)))

=AVERAGE(IF(M17<1,1,G17),(IF(G17<1,1,M17)))