rich123456

=IF(SUM($J48:$K48,$M48)*$L48<0,$L48,SUM($J48:$K48, $M48)*$L48)

"if you want to include 0 to have L48 as your solution then try this":

=IF(SUM($J48:$K48,$M48)*$L48<=0,$L48,SUM($J48:$K48 ,$M48)*$L48)

--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))


"rich123456" wrote in message
...

i have a formula in a cell that totals the amounts in that row.

here is the formula

=((J48-M48)*L48)+(K48*L48)

i need help adding this to this formula....

"if the total is less than 0 then use the number in L48"

any help here would be greatly appreciated.




--
rich123456