Excel If & Then

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