Thread: How to create a formula with multiple (IF) conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimmy jimmy is offline
external usenet poster
  
Posts: 59
Default How to create a formula with multiple (IF) conditions
HEllo,

Could you please help me creating a formula with multiple conditions?

IF "A3" greater than 100 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 150, then ("A3"*"A5"-"A9");
IF "A3" greater than 151 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 300, then ("A3"*"A5"-"A9");

Thanks for your help
Reply With QuoteReply With Quote