View Single Post
  #1   Report Post  
CP
 
Posts: n/a
Default IF Statements-Circular Reference

Hi,

I want to calculate results of an incentive that has 3 components all of
which are 'x' times $5 to calculate their total bonus.

Any combo of the 3 can reach a cap of $400. My question is when one of the
3 cells reaches the cap of $400, how do I get the other 2 to default to 0
without there being a circular reference?

Thanks