Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |