View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kdw
 
Posts: n/a
Default how do you set up an if, then formula in excel??

I am trying to create a formula so that if the information in A1 is within
this range then the result should be this.

A1 = 25
ranges 1-25
then 30 35 40 45 other

I cannot seem to get the formula quite right.

Please help