LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterate Circular Reference Brandt Excel Discussion (Misc queries) 1 August 3rd 05 11:43 PM
Highest Value / Circular Reference Help Josh M Excel Discussion (Misc queries) 1 May 23rd 05 07:33 PM
Highest Value / Circular Reference Help Josh M Excel Worksheet Functions 0 May 23rd 05 06:49 PM
Help solve a Circular Reference brupub Excel Worksheet Functions 6 February 14th 05 07:11 AM
Circular reference Pat Excel Discussion (Misc queries) 2 January 19th 05 05:52 AM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"