If condition meet

[maabbas]

=IF(A131=Yield!A1:A1020,(Sun!B131+Sun!P131)/Sun!K131,Sun!B131/Sun!K131)

Any help, I am not getting the right calculation

 

[FDibbins]

try entering with CRTL SHIFT enter

 

[maabbas]

try entering with CRTL SHIFT enter

Sorry I posted the wrong formula, please check the below formula, I tried using the CRTL SHIFT ENTER, but formula only calcuting right the first cell of range

=IF(Yield!A757:A1020=Sun!A131,Sun!B131/Sun!K131,IF(Yield!A1:A756=Sun!A131,(Sun!B131+Sun!P131)/Sun!K131,0))

 

[maabbas]

Sorry I posted the wrong formula, please check the below formula, I tried using the CRTL SHIFT ENTER, but formula only calcuting right the first cell of range

=IF(Yield!A757:A1020=Sun!A131,Sun!B131/Sun!K131,IF(Yield!A1:A756=Sun!A131,(Sun!B131+Sun!P131)/Sun!K131,0))

Here is more information, what I want, I have 7 Sheets from Monday to Sunday and a yield Sheet where we have product code and its standard yield (A1:A756), there are some product which we calculate yield as (finished goods/Inbound) and some are (finished goods+rejects/inbound) on yield sheet I separated both product from A1:A756 and A757:A1020. I am looking formula if I enter the product code in any day (Monday to Friday) sheet it will calculate the yield according to range

 

[jamtay317]

this is due to cell refrances, can you show us a sample worksheet?

 

[maabbas]

this is due to cell refrances, can you show us a sample worksheet?

YIELD SHEET

236	153%
64330	176%
65230	176%
60715	148%
64230	176%
A1397	180%
65530	161%
63030	150%
64630	161%
60113	160%
60325	147%
1044	115%
24561	156%
65730	161%
64830	161%
60108	147%
60315	145%
60116	139%
20203	120%
60004	149%
33160	155%
60243	193%
60249	193%
60216	139%
60008	147%
69000	75%
58208	150%
3762	179%
DAILY SHEET Product Pounds Average Standard Standard Paid Std. PPH Down Up-Time Up-Time Raw Raw Yield Standard Yield Reject Reject Code Produced lbs/Hr lbs/Hr Hrs Hrs Paid Time Hrs PPH lbs lbs/Hr % Yield Difference lbs % 20203 5000 0 0.00 0.00% 0.00 0 5000 0 0.00% 120.00% -120.00% 200 4.00% 236 5000 0 0.00 0.00% 0.00 0 5000 0 104.00% 153.00% -49.00% 200 4.00% 0 0.00 0.00% 0.00 0 0 0.00% 0.00% 0.00% 0.00% <colgroup><col span="2"><col><col><col span="4"><col><col span="2"><col><col span="2"><col><col span="2"></colgroup><tbody> </tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[jamtay317]

are the product codes ever the same?

 

[Marcelo Branco]

See if this works

=(B131+ISNUMBER(MATCH($A131,Yield!$A$1:$A$756,0))*$P131)/$K131

M.

 

[maabbas]

are the product codes ever the same?

Product code always stays same, if new product we just add the product code and standard yield.

 

[maabbas]

See if this works

=(B131+ISNUMBER(MATCH($A131,Yield!$A$1:$A$756,0))*$P131)/$K131

M.

its working but only for range A1 to A756, I have more product from range A757 to A1020 where I want formula to calculate Pound produce/Raw(B131/K131).