Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if, and statement
I need to do an if and statement something like this-
if A1=1 and A2x(A1)110 then no more than 10, but if A2=2 and A2xA125 then no more than 25 so if A2= 12 and A1=1 then the result will be 10 but if A2= 12 and A1=2 then the result will be 24 but if A2= 15 and A1=2 then the reult will be 25 I know it is a lot, but you can guys figure it out. |
#2
|
|||
|
|||
Try this:
=MIN((A1=1)*A2,10)+MIN(2*(A1=2)*A2,25) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ron1234" wrote in message ... I need to do an if and statement something like this- if A1=1 and A2x(A1)110 then no more than 10, but if A2=2 and A2xA125 then no more than 25 so if A2= 12 and A1=1 then the result will be 10 but if A2= 12 and A1=2 then the result will be 24 but if A2= 15 and A1=2 then the reult will be 25 I know it is a lot, but you can guys figure it out. |
#3
|
|||
|
|||
Another way...........
=IF(A1=1,MIN(A1*A2,10),IF(A1=2,MIN(A1*A2,25))) Vaya con Dios, Chuck, CABGx3 "ron1234" wrote in message ... I need to do an if and statement something like this- if A1=1 and A2x(A1)110 then no more than 10, but if A2=2 and A2xA125 then no more than 25 so if A2= 12 and A1=1 then the result will be 10 but if A2= 12 and A1=2 then the result will be 24 but if A2= 15 and A1=2 then the reult will be 25 I know it is a lot, but you can guys figure it out. |
#4
|
|||
|
|||
This worked great!! My formula was actually more complex than described. The
other reply did not work, but CLR's worked wonderfully, 3 hours of agony. THANKS!!!! "CLR" wrote: Another way........... =IF(A1=1,MIN(A1*A2,10),IF(A1=2,MIN(A1*A2,25))) Vaya con Dios, Chuck, CABGx3 "ron1234" wrote in message ... I need to do an if and statement something like this- if A1=1 and A2x(A1)110 then no more than 10, but if A2=2 and A2xA125 then no more than 25 so if A2= 12 and A1=1 then the result will be 10 but if A2= 12 and A1=2 then the result will be 24 but if A2= 15 and A1=2 then the reult will be 25 I know it is a lot, but you can guys figure it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions | |||
IF Statement difficulty | Excel Worksheet Functions |