Thread: Excel if/and
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jerminski73 jerminski73 is offline
external usenet poster
  
Posts: 41
Default Excel if/and
Thanks for solving my problem with this solution!!!
Jeremy

"Teethless mama" wrote:

=IF(B2<35,250,IF(B2<40,500,IF(B2<45,750,IF(B2<50,1 00,1250))))

Reply With QuoteReply With Quote