Please bare with this post I believe I’ve spelled it out in relatively easy to understand scenarios. It’s the only way I knew to ask the questions I have.
I am working on a spreadsheet for work. I need to develop a few formulas. Following are 3 scenarios.
Thank you in advance for any assitance.
Scenario 1:
Cells I21, L21, O21 get dollar values typed directly into them. I?m trying to find a way to say:
In cell I22 – ?If I21 is Less than L21 and Less than O21, then enter I21 here, otherwise leave it blank?
In cell L22 – ?If L21 is Less than I21 and Less than O21, then enter L21 here, otherwise leave it blank?
In cell O22 – ?If O21 is Less than I21 and Less than L21, then enter O21 here, otherwise leave it blank?
The cells left blank shouldn?t even have a ?$0.00? indicator.
Let?s say I21 = $11,000.00, L21 = $5,000.00, O21 = $8,000.00
In this case, L21 has the smallest dollar figure of the 3 and therefore, L22 would get populated with the amount $5,000.00 and the other two (I22 and O22) would be left blank.
Scenario 2:
In cells I16, L16, O16 there is text information, i.e. the name of the company from whence the numbers in row 21 came.
I would like to have cell I4 recognize the cell with the smallest dollar value, in this case L22 and populate cell I4 (itself) with the information from the text info that is in the winning column and row 16, which in this case is cell L16.
Let?s say the numbers in cell I21 came from ?ABC company?, cell L21 from ?RST company?, and cell O21 from ?XYZ company?.
These company names are entered into the appropriate corresponding cell in row 16.
In the example scenario L21 contained the smallest dollar value, thus L22 got populated with that dollar value, so I4 would get populated with the text from cell L16, which in this case is ?RST company?.
Scenario 3:
The final scenario. In cell L55 I would like to say, ?if the winning cell (in this case L22 $5,000.00) is less than $10,000.00 then put ?John Smith? here. If the winning cell is greater than or equal to $10,000.00 then leave this spot blank?.
I appreciate any assistance.