Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hey folks - sorry to barge in. I am a new user of excel and am trying to create a 6500 product spreadsheet for a website i am building. What i want to do is as follows: I have a column with my retail price. I want to create a column with my postage price. I want the postage price to be proportionate to the retail price. Example, if retail is less than £5 postage is £2.99. If retail price is more than £5 but less than £10, postage price is £3.99, if retail price is more than £10 but less than £15, postage price is £5.99 and so on and so forth. Question is, how to i put this in a formula. Tried lots of ways but keep messing it up. I would really really appreciate someone helping me out!! Thanks in advance Stewart -- stewartlogan ------------------------------------------------------------------------ stewartlogan's Profile: http://www.excelforum.com/member.php...o&userid=31371 View this thread: http://www.excelforum.com/showthread...hreadid=510637 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |