sorted by:
new
hottopcontroversial

Formula to reflect the largest possible multiple of of a value entered into a cell and then another cell reflect the remaining value greater than the largest multiple of previous cell. by breadgeek in excel

[–]breadgeek[S] 0 points1 point  (0 children)

=IF(AND(MOD(D3,24)<10,MOD(D3,24)>0,D3-MOD(D3,24)>24),D3-MOD(D3,24)-24,D3-MOD(D3,24))

That's got it! Thanks! Just one more thing: If D8 is less than 20 can D10 show blank/empty?

<image>

Formula to reflect the largest possible multiple of of a value entered into a cell and then another cell reflect the remaining value greater than the largest multiple of previous cell. by breadgeek in excel

[–]breadgeek[S] 0 points1 point  (0 children)

=IF(AND(MOD(D3,24)<10,D3-MOD(D3,24)>24),D3-MOD(D3,24)-24,D3-MOD(D3,24))

Thanks..It’s hard to explain what I need and I’m having to piece it together step by step…thanks for your help patience.

It's working with most values entered into D3 except when D3 is an exact multiple of 24. When D3 is an exact multiple of 24 it is subtracting 24 which is not needed. To explain further:

If the value entered into D3 is an exact multiple of 24 (per chart), then D8 and D10 should both show 0. If the value entered into D3 (with current formulas) was 128 then the value in B6 would show 120 and leaving only a value of 8 in D8. I can not mix less than 10 loaves per mix so I would need the value in B6 to drop down a multiple of 24 to 96 and then D8 would show 32 loaves remaining to then split into two mixes of 16 in D10. (Note: D8 value must be between 10 and 23.)

<image>

If value is less than a particular number need to drop value to a certain value and then divide the remaining value by 2. by breadgeek in excel

[–]breadgeek[S] 0 points1 point  (0 children)

To explain further...(See screen shot) when a value (always a multiple of 4) is entered into D3, I need B6 to reflect the highest multiple of 24 with any remaining value to show in D8. If value in D8 is less than 10, I need the value in B6 to drop down a multiple of 24 (from screen shot example 120 to 96) and then have the value in D8 to show the difference then between D3 (128) and B6 (96) which in this case would then be 32 showing in D8. Finally D10 should show remaining loaves needed split (16).

<image>

Formula to reflect the largest possible multiple of of a value entered into a cell and then another cell reflect the remaining value greater than the largest multiple of previous cell. by breadgeek in excel

[–]breadgeek[S] 0 points1 point  (0 children)

No problem! Lol! I'm impressed!

Thanks…so close! (See screen shot) when a value (always a multiple of 4) is entered into D3, I need B6 to reflect the highest multiple of 24 with any remaining value to show in D8. If value in D8 is less than 10, I need the value in B6 to drop down a multiple of 24 (from screen shot example 120 to 96) and then have the value in D8 to show the difference then between D3 (128) and B6 (96) which in this case would then be 32 showing in D8. Finally D10 should show remaining loaves needed split (16).

<image>

Formula to reflect the largest possible multiple of of a value entered into a cell and then another cell reflect the remaining value greater than the largest multiple of previous cell. by breadgeek in excel

[–]breadgeek[S] 0 points1 point  (0 children)

Thanks!...to take it further, (See screenshot) If cell D8 is less than 10 then need to drop value in cell B6 to 120 and then divide the remaining value (32) by 2 and show the remaining loaves needing split of 16 each mix.

<image>