Quote:
Originally Posted by rich123456
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.
|
Help from BRAZIL.
Dear Rich123456, Good Evening.
Try this one: =IF(((J48-M48)*L48)+(K48*L48)<0,L48,((J48-M48)*L48)+(K48*L48))
Tell me if it worked for you.
Have a nice day.
__________________
I hope it can help you.
Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
|