Thread: Excel 2007
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Automation_RS Automation_RS is offline
external usenet poster
 
Posts: 1
Default 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,