Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple IF
I need to check column A for the following:
1) IF A11<9999 then A1 2) IF A1<0 then 0 3) IF A110000 then 10000 A B 1 4,576 4,576 2 (6,719) 0 3 14,699 10,000 Column B is the results I want. How can I get this in one formula? Thanks Tim |
#2
|
|||
|
|||
Multiple IF
=IF(A1<=0,0,IF(A1=1,A1,IF(A1=10000,10000,"what do you want when blank")
Also, I covered for if A1 = 0 or A1 = 1, and you did not, so I might have done it wrong. ************ Anne Troy www.OfficeArticles.com "Tim Elhatton" wrote in message ... I need to check column A for the following: 1) IF A11<9999 then A1 2) IF A1<0 then 0 3) IF A110000 then 10000 A B 1 4,576 4,576 2 (6,719) 0 3 14,699 10,000 Column B is the results I want. How can I get this in one formula? Thanks Tim |
#3
|
|||
|
|||
Multiple IF
=min(max(0,A1),10000)
"Tim Elhatton" wrote: I need to check column A for the following: 1) IF A11<9999 then A1 2) IF A1<0 then 0 3) IF A110000 then 10000 A B 1 4,576 4,576 2 (6,719) 0 3 14,699 10,000 Column B is the results I want. How can I get this in one formula? Thanks Tim |
#4
|
|||
|
|||
Multiple IF
Here you go buddy..I tested it to make sure it works also:
=IF(AND(A11,A1<9999),A1,IF(A1<0,0,IF(A110000,100 00,""))) You may want to say =1 b/c you have a gap between 0 and 1. Hope this helps. James "Tim Elhatton" wrote: I need to check column A for the following: 1) IF A11<9999 then A1 2) IF A1<0 then 0 3) IF A110000 then 10000 A B 1 4,576 4,576 2 (6,719) 0 3 14,699 10,000 Column B is the results I want. How can I get this in one formula? Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |