| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple < and = question
I am trying to return certain values if certain criteria are met. Here is my
function, and I will break it down to make this easier to understand: =IF(D550,IF(E17=1,IF(D13<36.344,1,IF(D13=36.344, OR(IF(D13<39.549,2,IF(D13=39.549,3,0)))))),0) First, this cell will only display if D550, hence =IF(D550, Next, if cell E17=1 AND if D13<36.344, then I want a value of 1 returned. IF(D13<36.344,1 BUT... (still assuming that E17=1) if D13=36.344 or D13<39.549, I want a value of 2 returned. IF(D13=36.344,OR(IF(D13<39.549,2 and lastly (and still assuming that E17=1), if D13=39.549, I want a value of 3 returned. IF(D13=39.549,3 And to close out the function... ,0)))))),0) What I am getting with this current function is that if I type a number in D13 that is < 36.344, I get a correct value of 1 returned. However, if I have a number that is = 36.344 in D13, all I get is a "True" value returned and I can't figure out why. Please forgive me if this is not possible; I am pretty new at TRYING to understand multiple function Excel programming, and being an old BASIC programmer seems to be a detriment.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple < and = question
Try this:
=IF(AND(D550,E17=1,D13<36.344),1,IF(OR(D13=36.34 4,D13<39.549),2,IF(D13=39.549,3,0))) "TR Young" wrote: I am trying to return certain values if certain criteria are met. Here is my function, and I will break it down to make this easier to understand: =IF(D550,IF(E17=1,IF(D13<36.344,1,IF(D13=36.344, OR(IF(D13<39.549,2,IF(D13=39.549,3,0)))))),0) First, this cell will only display if D550, hence =IF(D550, Next, if cell E17=1 AND if D13<36.344, then I want a value of 1 returned. IF(D13<36.344,1 BUT... (still assuming that E17=1) if D13=36.344 or D13<39.549, I want a value of 2 returned. IF(D13=36.344,OR(IF(D13<39.549,2 and lastly (and still assuming that E17=1), if D13=39.549, I want a value of 3 returned. IF(D13=39.549,3 And to close out the function... ,0)))))),0) What I am getting with this current function is that if I type a number in D13 that is < 36.344, I get a correct value of 1 returned. However, if I have a number that is = 36.344 in D13, all I get is a "True" value returned and I can't figure out why. Please forgive me if this is not possible; I am pretty new at TRYING to understand multiple function Excel programming, and being an old BASIC programmer seems to be a detriment.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple < and = question
Ok, that is one step closer, however it is not returning a value of 3 if
D13=39.549. I really appreciate the help so far! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple < and = question
I think this needs to be an AND statement, not OR.
OR(D13=36.344,D13<39.549) Try this. =IF(AND(D550,E17=1,D13<36.344),1,IF(AND(D13=36.3 44,D13<39.549),2,IF(D13=39.549,3,0))) Regards, Paul "TR Young" wrote in message ... Ok, that is one step closer, however it is not returning a value of 3 if D13=39.549. I really appreciate the help so far! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple < and = question
Try =IF(D550,IF(E17=1,IF(D13<36.344,1,IF(D13<39.549,2 ,3)),0),0)
I assume you want it to return 0 if D55<=0, or if E17<1? You said: " Next, if cell E17=1 AND if D13<36.344, then I want a value of 1 returned. IF(D13<36.344,1 BUT... (still assuming that E17=1) if D13=36.344 or D13<39.549, I want a value of 2 returned." but in that case if you haven't satisfied the test for D13<36.344 then it must satify the test for D13=36.344, so I assume that you nean AND D13<39.549, rather than OR D13<39.549? -- David Biddulph "TR Young" wrote in message ... I am trying to return certain values if certain criteria are met. Here is my function, and I will break it down to make this easier to understand: =IF(D550,IF(E17=1,IF(D13<36.344,1,IF(D13=36.344, OR(IF(D13<39.549,2,IF(D13=39.549,3,0)))))),0) First, this cell will only display if D550, hence =IF(D550, Next, if cell E17=1 AND if D13<36.344, then I want a value of 1 returned. IF(D13<36.344,1 BUT... (still assuming that E17=1) if D13=36.344 or D13<39.549, I want a value of 2 returned. IF(D13=36.344,OR(IF(D13<39.549,2 and lastly (and still assuming that E17=1), if D13=39.549, I want a value of 3 returned. IF(D13=39.549,3 And to close out the function... ,0)))))),0) What I am getting with this current function is that if I type a number in D13 that is < 36.344, I get a correct value of 1 returned. However, if I have a number that is = 36.344 in D13, all I get is a "True" value returned and I can't figure out why. Please forgive me if this is not possible; I am pretty new at TRYING to understand multiple function Excel programming, and being an old BASIC programmer seems to be a detriment.... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple < and = question
Try =IF(D550,IF(E17=1,IF(D13<36.344,1,IF(D13<39.549,2 ,3)),0),0)
I assume you want it to return 0 if D55<=0, or if E17<1? You said: " Next, if cell E17=1 AND if D13<36.344, then I want a value of 1 returned. IF(D13<36.344,1 BUT... (still assuming that E17=1) if D13=36.344 or D13<39.549, I want a value of 2 returned." but in that case if you haven't satisfied the test for D13<36.344 then it must satify the test for D13=36.344, so I assume that you nean AND D13<39.549, rather than OR D13<39.549? -- David Biddulph "TR Young" wrote in message ... I am trying to return certain values if certain criteria are met. Here is my function, and I will break it down to make this easier to understand: =IF(D550,IF(E17=1,IF(D13<36.344,1,IF(D13=36.344, OR(IF(D13<39.549,2,IF(D13=39.549,3,0)))))),0) First, this cell will only display if D550, hence =IF(D550, Next, if cell E17=1 AND if D13<36.344, then I want a value of 1 returned. IF(D13<36.344,1 BUT... (still assuming that E17=1) if D13=36.344 or D13<39.549, I want a value of 2 returned. IF(D13=36.344,OR(IF(D13<39.549,2 and lastly (and still assuming that E17=1), if D13=39.549, I want a value of 3 returned. IF(D13=39.549,3 And to close out the function... ,0)))))),0) What I am getting with this current function is that if I type a number in D13 that is < 36.344, I get a correct value of 1 returned. However, if I have a number that is = 36.344 in D13, all I get is a "True" value returned and I can't figure out why. Please forgive me if this is not possible; I am pretty new at TRYING to understand multiple function Excel programming, and being an old BASIC programmer seems to be a detriment.... |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple < and = question
Ok, I got it!! Thanks for all the help!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple criteria/Countif question | Excel Discussion (Misc queries) | |||
| Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
| Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
| 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) | |||
Linear Mode
