Excel 2007
Hello,
is my first time here.
can someone show me how to resolve a problem in a Table with some diferent
conditions?
I put a number into a cell between 0 and 5.
In other cell I need to see a text with several conditions:
- If value =0 and <=2 - "A" - ("A", is the text)
- If value =2,1 and <=3,95 - "B" ("B", is the text)
- If value =3,96 and <=4,5 - "C" ("C", is the text)
- If value =4,6 and <=5 - "D" ("D", is the text)
I just already try several forms of crete a formula for this conditions, but
I could find.
The response is #Value ?
Best Regards,
|