Thread: Need to make a mark up table with more than 7 if statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Digace
 
Posts: n/a
Default Need to make a mark up table with more than 7 if statements
=IF(A3<4.99,A3*6,IF(A3<9.9,(A3*6.3)+5,IF(A3<24.99, (A3*6)+15,IF(A3<49.99,(A3*5.8)+12,IF(A3<74.99,(A3* 5.5)+8,IF(A3<99.99,(A3*5.25)+8,IF(A3<149.99,(A3*5. 25)+8)))))))
this is the formula so far but i need more than 7 statements is there a way
to put more than 7?
Reply With QuoteReply With Quote