Thread: Conditional formula problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Conditional formula problem
this will work

=IF(B6<=5,1,IF(B6<=10,4,"Uknown"))

"Spencer O." wrote:

I want to make a conditional formula with multiple variables, but I'm not
sure how (e.g. if B6<=5, display 1; if B65 but <=10, display 4; etc)
Reply With QuoteReply With Quote