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
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
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.
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..
Please also post some sample data with expected results.
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")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks