+ Reply to Thread
Results 1 to 5 of 5

showing difference value with out going over ref cell

  1. #1
    Registered User
    Join Date
    09-26-2006
    Posts
    9

    Unhappy showing difference value with out going over ref cell

    Example: a-c=d not to exceed value of b meaning b is the max value but need true number if it is below b

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You mean?

    =MIN(B1,A1-C1)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-26-2006
    Posts
    9

    close I think

    this is what I am doing tomake more sense of my question... this is regarding an insurance claim....col. a is total cost with tax, column b is depreciation value, col c is (a minus b), total with tax less depreciation which is acv......if they buy an item to replace it (Entered in column d) and it costs more than a ... the max they can have is b( dep value) but if it is less it should equal replacement cost (D)minus amount of total with tax (a) ..... you cant make money off insurance claim so if it cost more they max out at the difference being total depreciation is recoverable..

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Please also post some sample data with expected results.

  5. #5
    Registered User
    Join Date
    05-12-2004
    Posts
    15
    This is what I would do...

    cost depcr diff replacement status
    $40.00 $30.00 $10.00 $8.00 approved
    $35.00 $30.00 $5.00 $5.00 approved
    $40.00 $30.00 $10.00 $12.00 over limit
    $5.00 $3.00 $2.00 $3.00 over limit
    $15.00 $1.00 $14.00 $12.00 approved

    Col E has the following formula
    =IF(D1>C1,"over limit","approved")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1