Can you do multiple if then statements in excel?



Can you do multiple if then statements in excel?..

Answer / Varun Kumar Vivek

"Yes, you can perform multiple IF statements in Excel using nested IF statements or the IFS function. The IFS function checks multiple conditions at once and returns a value for the first true condition. For example: =IF(A1>10,"Greater than 10",IF(A1<5,"Less than 5","Neither greater nor less")). Here, the second IF statement is nested within the first."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I match two columns in excel?

1 Answers  


Can you link data from excel to word?

1 Answers  


How do you use the replace function in excel?

1 Answers  


How do I truncate a cell in excel?

1 Answers  


How do I copy and paste exact formatting in excel?

1 Answers  


How do you write a scenario summary report?

1 Answers  


What does a $2 mean in excel?

1 Answers  


How many rows are there in excel 2003?

1 Answers  


How do I remove infinite rows in excel 2016?

1 Answers  


How do you delimiter in excel?

1 Answers  


Explain macro in ms-excel.

1 Answers  


How do you unlock an excel spreadsheet for editing?

1 Answers  


Categories