| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF's Using Formulas from Other Cells
I could really use some help. I have only a basic knowledge of Excell
formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
would:
=IF(N1=0,0,IF(AND(N10,T1-T2=T3*T4),T3*T4,IF(AND(N10,T1-T2<T3*T4),T1- T2,"other circumstance"))) be of help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
cmkbird wrote:
I could really use some help. I have only a basic knowledge of Excell formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! =IF(N1<0,"unknown",IF(N1=0,0,IF((T1-T2)=(T3*T4),T3*T4,T1-T2))) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
Try
=IF(N1=0,0,IF(T1-T2<T3*T4,T1-T2,T3*T4)) -- Don Guillett Microsoft MVP Excel SalesAid Software "cmkbird" wrote in message ... I could really use some help. I have only a basic knowledge of Excell formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
Thanks! Worked like a charm. By the way, if N1 is never going to be less
than zero, do i have to have that first formula with "unknown"? "Glenn" wrote: cmkbird wrote: I could really use some help. I have only a basic knowledge of Excell formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! =IF(N1<0,"unknown",IF(N1=0,0,IF((T1-T2)=(T3*T4),T3*T4,T1-T2))) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
cmkbird wrote:
I could really use some help. I have only a basic knowledge of Excell formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! =IF(N1<0,"unknown",IF(N1=0,0,IF((T1-T2)=(T3*T4),T3*T4,T1-T2))) cmkbird wrote: Thanks! Worked like a charm. By the way, if N1 is never going to be less than zero, do i have to have that first formula with "unknown"? No, it wouldn't be necessary. But you didn't specify that it would never be less than zero, so I accounted for it. With that piece of information, I believe Don's solution is the most efficient. =IF(N1=0,0,IF(T1-T2<T3*T4,T1-T2,T3*T4)) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
Glenn,
Thanks a lot for all of your help. cmk "Glenn" wrote: cmkbird wrote: I could really use some help. I have only a basic knowledge of Excell formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! =IF(N1<0,"unknown",IF(N1=0,0,IF((T1-T2)=(T3*T4),T3*T4,T1-T2))) cmkbird wrote: Thanks! Worked like a charm. By the way, if N1 is never going to be less than zero, do i have to have that first formula with "unknown"? No, it wouldn't be necessary. But you didn't specify that it would never be less than zero, so I accounted for it. With that piece of information, I believe Don's solution is the most efficient. =IF(N1=0,0,IF(T1-T2<T3*T4,T1-T2,T3*T4)) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's Using Formulas from Other Cells
Or =IF(N1=0,0,MIN(T1-T2,T3*T4)) ?
-- David Biddulph "Don Guillett" wrote in message ... Try =IF(N1=0,0,IF(T1-T2<T3*T4,T1-T2,T3*T4)) -- Don Guillett Microsoft MVP Excel SalesAid Software "cmkbird" wrote in message ... I could really use some help. I have only a basic knowledge of Excell formulas, and I am trying to do the following calculation in a cell using comparisons of other cells. N1, and all the T cells are other cells that i am using for this formula If N1=0, then zero If N10, and T1-T2=T3*T4, then T3*T4 If N10 and T1-T2<T3*T4, then T1-T2 I hope this makes sense. Thanks in advance to anyone who can help me. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to avoid multiple IF's by LOOKUP's? | Excel Discussion (Misc queries) | |||
| Multiple IF's to Select a Value | Excel Worksheet Functions | |||
| Multiple If's and OR's | Excel Worksheet Functions | |||
| multiple IF's ? | Excel Worksheet Functions | |||
| Formula with multiple IF'S | Excel Discussion (Misc queries) | |||
Linear Mode
