Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default formula
=IF(B1<6,1,2)
OR
=1+(B1=6)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jjackson" wrote in message
...
what would the formula be for b2 to=1 if b1 is less than 6, and b2 to=2 if
b1
is 6 or greater


Reply With QuoteReply With Quote