Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I formulate a high price column
I need to know the highest price I have ever paid for a product. In my
inventory, I update prices monthly, changing the previously recorded price. If the "new price" is more than the price recorded in the "high price" column, I want that price to change to the "new Price" amount. I have tried using the MAX formula in conjunction with the IF formula, but it is not working properly because if the "New Price" is in between the the two prices, it records that "New Price". Any suggestions? (I am pretty much a novice at this, so please try to keep it simple. Note: I have Excel 2003 & I posed this question already & got a response, (about using a VBA code) but I didn't understand it all. I was told to "right-click on tab", - what tab? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I formulate a high price column
My first suggestion is to post the formula you are using. That's the only way
people can help you. Regarding VBA code, post your question to the .programming group. The 'tab' they are referring to is the sheet name -- it's at the bottom of your worksheet. The default name is Sheet1. -- Regards, Fred "Lou New At Excel" wrote in message ... I need to know the highest price I have ever paid for a product. In my inventory, I update prices monthly, changing the previously recorded price. If the "new price" is more than the price recorded in the "high price" column, I want that price to change to the "new Price" amount. I have tried using the MAX formula in conjunction with the IF formula, but it is not working properly because if the "New Price" is in between the the two prices, it records that "New Price". Any suggestions? (I am pretty much a novice at this, so please try to keep it simple. Note: I have Excel 2003 & I posed this question already & got a response, (about using a VBA code) but I didn't understand it all. I was told to "right-click on tab", - what tab? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Can it be done | Excel Worksheet Functions |