Need to add Additional Query in the IF formulae i have [SOLVED]

[aksan782]

I have a formulae

IF(U1<>"",IF(W1="Approved",TEXT(U1,"mm…

Basically this formulae is used to place the Month and year detail on U1 if W1=Approved.


The challenge i have is in W Column i have multiple entry such as Approved, Pre-Approved, N/A. Now i want to add "Pre-Approved" too in the formulae.


Any help would be appreciated.


Thanks in advance.

 

[NARAYANK991]

Hi Aksan ,


When you say in column W you have multiple entries , I assume that there are all the specified entries ( Approved , Pre-Approved , N/A ) possible , but any one cell will have only one entry.


You can modify your formula as :


IF(U1<>"",IF(OR(W1="Approved",W1="Pre-Approved"),TEXT(U1,"mm…


The OR function returns TRUE if W1 is either Approved or Pre-Approved.


Narayan

 

[aksan782]

Thanks a Lot!!! It worked.