if then formula
 

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.

if then formula
 

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

if then formula (CORRECTION on Earlier POST)
 

rich123456,
This a Correction of earlier posting, I did include for M48 being negative.

=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

if then formula
 

"rich123456" wrote:
=((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"

=IF((J48-M48+K48)*L48<0,L48,(J48-M48+K48)*L48)

I took the liberty of making some algebraic simplifications as well.

If all of the values in J48, K48, L48 and M48 are non-negative, you can
simplify the IF() expression as follows:

=IF(J48+K48<M48,L48,(J48-M48+K48)*L48)

it worked !!!!

thanks so much for the help.
I'm somebody now!