Forum Discussion
IF STATEMENT
CAN I GET SOME HELP CODING THIS. I HAVE BEEN AT IT NOW FOR 2 DAYS. CANNOT FIGURE IT OUT.
WE HAVE AN INVENTORY SYSTEM WHERE PARTS GET MOVED FROM ONE LOCATION TO ANOTHER. DAILY. SO WE USE A DROP DOWN TO TELL WHICH TECH HAS THE PARTS. THIS ALLOWS US TO TRACK WHERE THE PART IS AT ALL TIMES.
I NEED TO DELETE A CELL'S VALUE AND LEAVE IT BLANK UNTIL THE PART COMES BACK TO WAREHOUSE. SO SAY COLUMN A IS THE LOCATION AND COLUMN B IS THE SHELF I HAVE THE PART STORED IN THE WAREHOUSE.
WHEN CELL A HAS A VALUE OF "TECHS NAME" I WANT CELL B TO DELETE ITS CURRENT SHELF AND LEAVE THE CELL BLANK.
In Excel, you can use a simple IF statement to clear the contents of a cell in Column B when a corresponding cell in Column A contains a specific value (in this case, "TECHS NAME").
Here is a formula that you can use in cell B1 and copy it down as needed:
=IF(A1="TECHS NAME", "", B1)
This formula checks if cell A1 contains "TECHS NAME." If it does, it leaves cell B1 blank; otherwise, it keeps the current value in cell B1.
Here is how to implement this:
- Open your Excel spreadsheet.
- Click on cell B1 (or the cell where you want to apply this formula).
- Enter the formula =IF(A1="TECHS NAME", "", B1).
- Press Enter.
Now, if cell A1 contains "TECHS NAME," cell B1 will be cleared. You can drag the fill handle (a small square at the bottom right corner of the selected cell) down to apply the formula to multiple rows in Column B. The formula will automatically adjust to the respective rows in Column A.
The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.
