Excel If & Then

Closed
Abhilash - Feb 9, 2010 at 08:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 08:53 AM
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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 08:53 AM
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","")))
0