Thread: Complex Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saul Saul is offline
external usenet poster
 
Posts: 6
Default Complex Formula

Please help with how to write this formula.

If A1 <= 10 then 500
If A1 10 and <= 20 then 600
If A1 20 and <= 30 then 700

Thanks in advance!