If formula problem

Dear Friends,
I'm getting error in 'if' formula in attached file.

Solution please!

Thanking you in anticipation.

Mukesh

Hi Mukesh,
What are you expecting in the remark column (W9)? Is it "Sanctioned"?

If so is this what your after?

Hello moppyau,
The condition is as follows:

If p9= "" then ""
IfP9= any date then "Sanctioned"
if p9= dash sign then the remark in w9 should be "-"

In short if the p9 is blank the remark should be blank, if p9 contains any date then the remark in w9 should be "Sanctioned", If the cell p9 contains dash sign then remark in w9 should be "-".

Thank you.

Mukesh

=IF(P9="","",IF(ISNUMBER(P9),"Sanctioned",IF(P9="-","-","")))

Hello Teethless mama,
Thank you for solution. It's working fine. I think there isno need of last ',""' because the first if does this job.

Now my problem is solved. Thank you.

Mukesh

Originally Posted by mukeshbaviskar

Hello Teethless mama,
Thank you for solution. It's working fine. I think there isno need of last ',""' because the first if does this job.

Now my problem is solved. Thank you.

Mukesh

You're welcome!