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.
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...
=if(S11>=90,''A+'',if(S11>=70,''A'',if(S11>=60,''B+'',if(S11>=40,''B'',if(S11>=30,''c'',''D'')))))
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.
Solution:
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
=if(S11>=90,"A+",if(S11>=70,"A",if(S11>=60,"B+",if(S11>=40,"B",if(S11>=30,"c","D")))))
check the attached excel file
Attachments (1)
multi-if.xlsx
8.57 KB
0 Votes
0 Comments
Login or Sign up to post a comment