Thread
:
how i dow the following formal in excel
View Single Post
#
4
Chris Bode
Member
Location: Sweden
Posts: 30
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
Reply With Quote
Chris Bode
View Public Profile
Send a private message to Chris Bode
Visit Chris Bode's homepage!
Find all posts by Chris Bode