Which of the following formulas in MS Excel will correctly display 'High' if cell A1 is greater than 80, 'Medium' if A1 is between 40 and 80 (inclusive), and 'Low' otherwise?

Question

Computer · MS Excel

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

=IF(A1>80, 'High', IF(A1≥40, 'Medium', 'Low'))

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on MS Excel?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer · MS Excel

Who among the following founded the 'Forward Bloc'?

Which of the following statements regarding the Harappan Civilization is NOT correct?

Which ruler is generally credited with unifying much of Northern India under a single empire for the first time?

Answer 1

=IF(A1>80), 'High', 'Low'

Answer 2

=IF(A1>80, 'High', IF(A1<40, 'Low', 'Medium'))

Answer 3

=IF(A1>80, 'High', 'Medium', 'Low')

Answer 4

=IF(A1>80, 'High', IF(A1≥40, 'Medium', 'Low'))

Related Practice Questions