Hi friends,
Please see below attachments for better understanding.
In that attachment I want multiply O6 with P1, AND
multiply P6 with P1
Please edit my O6, P6 formulas......
Thank you
Hi friends,
Please see below attachments for better understanding.
In that attachment I want multiply O6 with P1, AND
multiply P6 with P1
Please edit my O6, P6 formulas......
Thank you
That doesn't help to explain at all.
Please mock up what you want in a separate workbook. It is also a lot easier with mock data where you just illustrate the problem, instead of giving the entire thing. That way there is less for us to look at and we are able to pin-point the issue.
Ok, Now you can check attachment,
Rule 1 : From N6, I want min rate to maximum rate
Rule 2 : N6 & O6 multiply with O1
Last edited by rajeshn_in; 11-09-2016 at 01:45 AM.
Please explain - in words - what you are trying to do here.
This formula seems to do the same as your longer 1...
=SMALL(IF(($D$2:$D$5=$M$1)*($E$2:$E$5=$M$2)*($B$2:$B$5<=$M$3)*($C$2:$C$5>=$M$3),$G$2:$G$5),ROWS($N$6:N6))
vs
=IFERROR((SMALL(IF($D$2:$D$5=$M$1,IF($E$2:$E$5=$M$2,IF($B$2:$B$5<=$M$3,IF($C$2:$C$5>=$M$3,$G$2:$G$5+ROW($G$2:$G$5)/10^10)))),ROWS($N$6:N6))),"")
Is this not working for you? If not, what did you want?
This?Rule 2 : N6 & O6 multiply with O1
=O6*P6*$O$1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok,
=SMALL(IF(($D$2:$D$5=$M$1)*($E$2:$E$5=$M$2)*($B$2:$B$5<=$M$3)*($C$2:$C$5>=$M$3),$G$2:$G$5),ROWS($N$6:N6))
with this formula, other cells (L6, M6, O6, P6) values are not coming.....
=O6*P6*$O$1 MEANS
=(SMALL(IF(($D$2:$D$5=$M$1)*($E$2:$E$5=$M$2)*($B$2:$B$5<=$M$3)*($C$2:$C$5>=$M$3),$G$2:$G$5),ROWS($N$6:N6))) * $O$1
Same as in P6 formula * $O$1
Explain in words what you are trying to do
Actually I want smallest to highest value from N6 to N9 comparing with table A1:J5, with some IF conditions
Thats way I try below formula in N6 (excel array )
=(SMALL(IF(($D$2:$D$5=$M$1)*($E$2:$E$5=$M$2)*($B$2:$B$5<=$M$3)*($C$2:$C$5>=$M$3),$G$2:$G$5),ROWS($N$6:N6)))
After that using another formula I get values in L6, M6, O6, P6 according to N6 (excel array )
=IFERROR(INDEX($A$2:$A$5,MATCH(N6,$G$2:$G$5+ROW($G$2:$G$5)/10^10,0)),"")
and after that I want multiply N6 with O1,
After that I want to multiply O6 with O1.
But problem is, when I am trying to multiply N6, then L6, M6, O6, P6 values are not coming
Last edited by rajeshn_in; 11-09-2016 at 03:57 AM.
O6
=iferror((index(($h$2:$h$5)+($i$2:$i$5),match(n6,$g$2:$g$5+row($g$2:$g$5)/10^10,0)))*$o$1,"")
p6
=iferror((index(($j$2:$j$5),match(n6,$g$2:$g$5+row($g$2:$g$5)/10^10,0)))*$o$1,"")
Ok, its working great...
N6 = ?
L6 = ?
M6 = ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks