| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula??
I have 10 cells with different prices. I want to be able to automatically
calculate, and I am not sure of the formula that will allow me to do this. I want the formula to automatically look at the list of prices and IF the price is greater than the price in column A, then it will look in column B. It it is not greater than column B, that price will be put in the cell with the formula. If the price is not greater than column B, then it will move down the remainding columns until it finds the price that is not greater than. Any help with this would be GREATLY appreciated. -- Thanks-- Bambi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
