Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2012-11-03 04:34:11 +0200

ROSt52 gravatar image

"The value of 80 is ambiguous" , this is the important point and this is also a problem in the first formula =IF(0<=A1<=80;"A";IF(80<=A1<=95;"B";"C")) in this formula there are 2 questions, which contradicts each other: ...A1<=80... and ... 80<=A1... both questions include the "=". In one the "=" must be removed.