| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to add "IF" statements?
Here is an "IF" statement for cell E10:
=IF(OR(E10={"la","pd","ea","pdx","mc","v","pr"}),7 .75,IF(OR(F10= {"la","pd","ea","pdx","mc","v","pr"}),7.75,IF(OR(G 10= {"la","pd","ea","pdx","mc","v","pr"}),7.75,IF(OR(H 10= {"la","pd","ea","pdx","mc","v","pr"}),7.75,IF(OR(I 10= {"la","pd","ea","pdx","mc","v","pr"}),7.75,0))) )) Is there a function to allow me to count how many times a certain text is repeated and have that multiplied by 7.75? For example, in the above "IF" statement, suppose E10 has "la", H10 has "v", and I10 has "pr". I would like to have the function recognize 3 instances of text and be multiplied by 7.75 to get 23.25 (or just have 23.25 in the cell whenever 3 instances of text are in cells E10:I10). Any suggestions are welcomed. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
