How can we help you today?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Welcome to 'Sikkhon' User Forum

Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users. You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.

Multiple IF statements in Excel not working

Un Answered

I am trying to set a multiple IF statement for my MS excel sheet. but, when i set the formula i get back an error. 

please check below

Here's the formula...


Any thoughts on this? If possible I would also like to keep on adding to this, so if by chance there is more within a week it calculates it properly.



The problem you had is that for double quotes "" . in your formula you used single quote multiply. that's the problem. 

the formula should like below 


check the attached excel file 

0 Votes


Login or Sign up to post a comment