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" <(EMail Removed)> wrote in message
news:(EMail Removed)...
i have a formula in a cell that totals the amounts in that row.
here is the formula
=((J48M48)*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
