Thread: Formula for < and results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN TMF in MN is offline
external usenet poster
  
Posts: 12
Default Formula for < and results
a b
1 Sue 8
2 Ann 5
3 Sue 4

I would like a formula if A=Sue and B is =4 but =<6 the result is 1.

THANK YOU!!!!
Reply With QuoteReply With Quote