You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
HI,
I need circular formula to get results of cells marked in Yellow in such a way that actual value of Cells B3 and D3 comes closer to std value of cells B2 and D2 .
MacBook Pro 16″
Sorry its C3
I need to get qty cream , water and SMP to be added to raw milk to get near the standard value.
=SUMPRODUCT(B4:B8,C4:C8)÷B$3 and =SUMPRODUCT(B4:B8,D4:D8)÷B$3
Where i have entered data in yellow manually.
I think I understand what you mean. You want to derive the values in B7:B9 that result in the value you want in C3?
If so, that's the kind of problem one might use the "Solver" in Excel to derive the values.
Theoretically, one could write a script to emulate what Solver does. But that would be complicated.
Is there a reason you can't manually enter values in B6:B8 until you get close to what you want in C3?
SG
Could you clarify? I see no value in B2. What are your formulas?
SG
Formula for Numbers to get value of specific cell
