Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to set-up a formula that will fill-in a value in a cell.
In a column (c7:c210) they are three value, either S, D, T. Based on what alpha character is found, I want to insert a value, either 100 if S, 200 if D, or 300 if T. I went to the bottom of the worksheet and set-up a location for S(A212), D(A213), and T(A214) and a value for each in the adjacent 'B' column. I can get a single logic statement to work: If(C7:c210,a212,b212) and that works great for a single condition. But my question is how do I set up a formula to cover all three conditions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 If Statements between 2 values Q | Excel Worksheet Functions | |||
4 different if statements, not working | Excel Worksheet Functions | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |