Hey There,
I am really struggling with a formula and cannot figure out what to do, was wondering if you would know.
Here is what I am looking to get.
Some info, let's say that:
C1=5,000
I would like the cell D1 to show:
If C1 is smaller than 5,000, I want D1 to Show "NO".
If C1 is Equal or Bigger than 5,000, BUT smaller than 10,000, D1 will say "LEVEL 1"
If C1 is Equal or Bigger than 10,000, BUT smaller than 15,000, D1 will say "Level 2".
If C1 is Equal or Bigger than 15,000, BUT smaller than 20,000, D1 will say "Level 3".
If C1 is Equal or Bigger than 20,000, BUT smaller than 25,000, D1 will say "Level 4".
Can something like this be done?
Thanks in advance
Arthur
Bookmarks