Nested if formula clashes
 

How do i tell a formula to take an number between 600 and 799?

Nested if formula clashes
 

=if(and(a2=600,a2<800),1,2)


--
Don Guillett
SalesAid Software

<=IF(E5<600,"Geen medalje",IF(E5; wrote in
message ...
How do i tell a formula to take an number between 600 and 799?

Nested if formula clashes
 

=IF(AND(E5600,E5<799),"Green", "Red")

This is better asked in the worksheet.functions group not programming.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<=IF(E5<600,"Geen medalje",IF(E5; wrote in
message ...
How do i tell a formula to take an number between 600 and 799?