Excel formula

Let’s say cell B5 has a number between 0 and 100, where 0-33 is low, 34-66 is medium and 67-100 is high. Here’s a formula to display the appropriate text
=IF(B5<34,"Low",IF(B5<67,"Medium","High"))
Then just drag down the column

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • LinkedIn
  • Technorati
  • Tumblr
This entry was posted in Microsoft. Bookmark the permalink.

Comments are closed.