View Single Post
  #4   Report Post  
Chris Bode Chris Bode is offline
Member
 
Location: Sweden
Posts: 30
Default

Let A1 represents the cost you have mentioned
Select cell B1 and enter following formula
=IF(AND(A1=1,A1<=10,10,IF(AND(A1=20,A1<=30,20))


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com