I have a value in cell B1 - its a free text name with no formula in it - say this name is Black.
would it be positble to write up a formula in cell D1 which would change the value in B1 based on if the status is put to archived so it changes the name to "archived data"
was thinking something along the lines of
=if(A1="archived",Replace(B1,B1,"archived"), "") but not getting any results with this
would it be positble to write up a formula in cell D1 which would change the value in B1 based on if the status is put to archived so it changes the name to "archived data"
was thinking something along the lines of
=if(A1="archived",Replace(B1,B1,"archived"), "") but not getting any results with this
| A | B | C | D | |
| Status | Surname | date of discharge | ||
| 1 | Active | Black | 12/12/25 | |
| 2 | Active | Simpson | 10/5/24 | |
| 3 | Discharged | Power | 12/10/22 | |
| 4 | Archived | Times | 08/08/21 |
