Pr0ximitea
New Member
- Joined
- Apr 27, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
I am putting together a spreadsheet that needs to be flexible with numbers but quick and easy to amend. I'm a bit poor at explaining so hopefully this will make sense!
I have a Capacity Cell (D5) - context is products that can go down a line in an hour.
Linked to this cell are 9 rows (simple =D$2 formula), each one representing an hour of the day, with two containing adjustments for breaktimes (/3 for 20 mins break, /2 for 30 mins break).
However, where certain products go down the line, the capacity decreases by 60 (e.g. 180 is the capacity per hour normally, reduces down to 120 when a certain product is being produced).
Therefore, what I want to do is have a cell reference the Capacity in D5, however if the word 'Silverside' appears in the Description box beside it, it is reduced by 60.
Below is the reference I attempted to use (also didn't work) - but the problem with this is that it would be static with 120 or 180 - I want it to reference what is in cell D5 on a normal basis, however when the word 'Silverside' appears in the H23:H28 section, I want it to deduct -60 from that value.
=IF(H23:H28="Silverside","120",IF(H23:H28<>"Silverside","180"))
Am I being overambitious or is this potentially a formula that someone could please share with me? Again, apologies for my poor explaining skills, and thank you in advance for any help!
I am putting together a spreadsheet that needs to be flexible with numbers but quick and easy to amend. I'm a bit poor at explaining so hopefully this will make sense!
I have a Capacity Cell (D5) - context is products that can go down a line in an hour.
Linked to this cell are 9 rows (simple =D$2 formula), each one representing an hour of the day, with two containing adjustments for breaktimes (/3 for 20 mins break, /2 for 30 mins break).
However, where certain products go down the line, the capacity decreases by 60 (e.g. 180 is the capacity per hour normally, reduces down to 120 when a certain product is being produced).
Therefore, what I want to do is have a cell reference the Capacity in D5, however if the word 'Silverside' appears in the Description box beside it, it is reduced by 60.
Below is the reference I attempted to use (also didn't work) - but the problem with this is that it would be static with 120 or 180 - I want it to reference what is in cell D5 on a normal basis, however when the word 'Silverside' appears in the H23:H28 section, I want it to deduct -60 from that value.
=IF(H23:H28="Silverside","120",IF(H23:H28<>"Silverside","180"))
Am I being overambitious or is this potentially a formula that someone could please share with me? Again, apologies for my poor explaining skills, and thank you in advance for any help!