Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Iterate Circular Reference | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
Circular reference | Excel Discussion (Misc queries) |