Excel formula for filling another cell

ejeruratyuuga - Mar 12, 2022 at 09:46 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Apr 7, 2022 at 11:26 AM
I have four columns in excel. Column A is named "Date" while Column B is named "Day". Column B depends on the value in Column B and I got the Formula for any specific date for column B and that's not my concern anymore.
Column C is designated for formula and is named "Formula".

Column B and C are to be hidden (not a problem).
Column D is Activities.
My concern is I want Column C to not contain any formula but I want it to be filled with values based on another column or cell.
Column B, C, and D are the connected now to each other.
Column C will contain the formula that will fill Column D based on Column B.
Column D are editable cell meaning to say, I will type in some of the cell in Column D while other cell in Column D are automatically filled based on Column B using the formula in Column C.
Here's a scenario.

You will enter formula in Column C.
If B2 is "Sunday" or "Saturday" , then either "Sunday" or "Saturday" will be automatically copied in Column D.
And if Column B are Weekdays, I will type in the Activities I've done in that day.

Is it possible? If so, what formula or Codes should I be using?

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Apr 7, 2022 at 11:26 AM
Hi ejeruratyuuga,

How about you put this formula in D2:
=IF(B2="Sunday","Sunday",IF(B2="Saturday","Saturday",""))

Drag the formula down as far as needed and when a cell in column D is empty, you will know to enter an Activity there.

Best regards,
Trowa
0