C
Ced
I have a excel doc which takes
B9 ($12,000) represents value of product
B11 =sum(b9*.01) equals $1,200
B13 (125,000) represents mileage
B15 =IF(B13>0,1-(B13/100000),1)
B17 (25%) represents a modifier
B25 SUM(B11*B15*B17) represents final solution of -$75.00
My problem is this when B13 is over 100,000 the result in B15 is negative
which makes the final solution in B25 a negative number. If calculation in
B25 is negative I would like it to return a value of zero. Any help would be
appreciated.
B9 ($12,000) represents value of product
B11 =sum(b9*.01) equals $1,200
B13 (125,000) represents mileage
B15 =IF(B13>0,1-(B13/100000),1)
B17 (25%) represents a modifier
B25 SUM(B11*B15*B17) represents final solution of -$75.00
My problem is this when B13 is over 100,000 the result in B15 is negative
which makes the final solution in B25 a negative number. If calculation in
B25 is negative I would like it to return a value of zero. Any help would be
appreciated.