Kindly help me to get the desired result in enclosed excel

Replies to This Discussion

Permalink Reply by Avais on March 9, 2010 at 1:06am

here you go....

Attachments:

• Book1- solution.xlsx, 15 KB

▶ Reply to This

Permalink Reply by Rajiv on March 9, 2010 at 1:11am

thanks avais...

▶ Reply to This

Permalink Reply by GURVINDER SINGH KHARBANDA on March 9, 2010 at 9:46am

You have enclosed TRUE in double quotes. Remove the double quotes: The following sytex will give the result as Follow-up
=IF(OR(I7=TRUE,J7=TRUE),"FollowUP","Rejected")

Hope this will give the desired results.
Regards
Gurvinder s Kharbanda

▶ Reply to This