Excel If & Then [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I wanted to know that, in Excel 2007, what is the formulae if Cell B12 has a drop down list of 3 range and if we select a particular range then cell C12 must enter a custom text.

E.G.: Suppose Cell B12 has a drop down list of 3 range(Normal, High, Urgent)
Now if we select Normal in cell B12 then cell C12 must show (To be considered in 15 days) and
If we select High in cell B12 then cell C12 must show (To be considered in 5 days) and
If we select Urgent in cell B12 then cell C12 must show (To be considered in 02 days)

Please suggest soon if this can be done.

Regards

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
will this work for you in cell c12

=if(b12="Urgent","To be considered in 02 days", if(b12="High", "To be considered in 05 days", if(b12="Normal","To be considered in 15 days","")))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!