| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
Quote:
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#6
|
|||
|
|||
|
Quote:
thanks so much for the help. I'm somebody now! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
