pLEASE hELP Me Rectify the error - Your formula is missing parenthesis

=if(x2="cancelled", 0, if(or(b2="flipkart", b2="amazon india" ,b2= "rediff shopping", b2="fabfurnish", b2="fashionara",b2= "snapdeal",b2= "rangrage store"), al2-af2, 0

Originally Posted by gmr4evr1

You need to add 2 parenthesis at the end of the formula.

Can u please correct me equation and send it.. its very urgent. its a job interview test so need to send it immediately. Pls Pls...

=IF(X2="cancelled", 0, IF(OR(B2="flipkart", B2="amazon india",B2= "rediff shopping", B2="fabfurnish", B2="fashionara",B2= "snapdeal",B2= "rangrage store"), AL2-AF2, 0))

Originally Posted by protonLeah

Asking other people to answer your test questions is cheating... Do the interviewers know it's not your own work?

Hello Ms. Johnson,

I am asking help only for the closure part of the formula, I have written the whole thing on my own.. Since this forum helped me everytime yesterday to solve, I became to dependent. But I still have to be dependent on this thread so whatever the problem is I will have to post it here.

Thank You for your time

Regards
Bhargav Seeram