Hello I am trying to figure what formula I can use when a value in one column matches a word in one column and use a number in the same row but a different column and then multiply that number by a number in a different cell. See table and description below:
|
A |
B |
C |
D |
| 1 |
TRUE/FALSE |
PERCENT |
|
|
| 2 |
FALSE |
.30 |
3456 |
1209.6 |
| 3 |
TRUE |
.35 |
|
|
| 4 |
FALSE |
.40 |
|
|
| 5 |
FALSE |
.45 |
|
|
More detail - Trying to populate cell D2 by using a formula from a multiple of variables. Column A is populated from other data. TRUE could be in any of the 4 rows (2-5). Depending in which row in column A matches TRUE. Then use the number in that same row from column B. Example A3 = TRUE so use value in B3 = .35. Then multiply that number (.35) times the number in C2 and populate it in D2.
Example if A2 = TRUE use .30 (B2) * 3456 (C2) = 1036.8 (D2)
Example if A4 = TRUE use .40 (B4) * 3456 (C2) = 1382.4 (D2)
Example if A5 = TRUE use .45 (B5) * 3456 (C2) = 1555.2 (D2)