Thread: Nested if formula clashes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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?

Reply With QuoteReply With Quote