Basic formula i need

[max2598]

HI,
I want to know which formula should i put in Cell C2, D2 & E2

so when i put ANYTHING in Cell B2 (it could be text or number)

some text should automatically show in C2, D2 & E2 as following as shown in below picture.

Cell C2 should show Care Center.

Cell D2 should show Driver

Cell E2 should show Todays date.


Untitlhjked.jpg


Thanks.

[63falcondude]

Try these:

C2 =IF(B2="","","Care Center")

D2 =IF(B2="","","Driver")

E2 =IF(B2="","",TODAY())

Just note that TODAY() will continuously re-calculate and will therefore always show the current date unless you copy/paste as values.

[max2598]

Try these:

C2 =IF(B2="","","Care Center")

D2 =IF(B2="","","Driver")

E2 =IF(B2="","",TODAY())

Just note that TODAY() will continuously re-calculate and will therefore always show the current date unless you copy/paste as values.

Thanks allot.

[63falcondude]

You're welcome, happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[avk]

I have one doubt, here you given only one sample. But let me know column "C" handover to, only one department name or is it multiple. Same for column "D" Receiving by "Driver" every time or some one other also.
If is it multiple department or person, then attach your sample file with 5-6 sample data.