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 N1>0, and T1-T2>=T3*T4, then T3*T4

If N1>0 and T1-T2<T3*T4, then T1-T2

I hope this makes sense. Thanks in advance to anyone who can help me.

Thank you!

would:

=IF(N1=0,0,IF(AND(N1>0,T1-T2>=T3*T4),T3*T4,IF(AND(N1>0,T1-T2<T3*T4),T1-

T2,"other circumstance")))

be of help?

=IF(N1=0,0,IF(AND(N1>0,T1-T2>=T3*T4),T3*T4,IF(AND(N1>0,T1-T2<T3*T4),T1-

T2,"other circumstance")))

be of help?

=IF(N1<0,"unknown",IF(N1=0,0,IF((T1-T2)>=(T3*T4),T3*T4,T1-T2)))

Try

=IF(N1=0,0,IF(T1-T2<T3*T4,T1-T2,T3*T4))

--

Don Guillett

Microsoft MVP Excel

SalesAid Software

XXXX@XXXXX.COM

=IF(N1=0,0,IF(T1-T2<T3*T4,T1-T2,T3*T4))

--

Don Guillett

Microsoft MVP Excel

SalesAid Software

XXXX@XXXXX.COM

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"?

than zero, do i have to have that first formula with "unknown"?

> 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))

1. Formula for several IFs in 1 single line/cell ..??

3. Please help with formula (multiple ifs to determine due date)

5. Help simplifying a formula with multiple if's added together...

6. Formula result based on Multiple IFs

7. Help simplifying a formula with multiple if's added together..

8. New IFS interface (jfs.ifs, udf.ifs for example)

9. multiple ifs. multiple fields, multiple criteria

10. Sum formula using cells in multiple sheets

11. Using the LEFT formula for multiple cells

12. Using a single cell refernce to change multiple formulas

13. Using a single cell in multiple formulas

14. How do I create a formula using cells from multiple worksheets?

15. Formula works in some cells of a colum but not others?

8 post • Page:**1** of **1**