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
|