Forum Discussion
Solved
Microsoft Office Excel formula
See attached image.
- Looking for formula that will look at column A and determine whether is is "E-Check" or just "Check".
- Then depending on what it finds, it will place the value from column B into corresponding cell.
- Then if it does NOT have E-Check in the cell in Column A, then the value of cells in Column C are left blank.
- Two ways to do it.
If you have SPILL capability:
=IF(A2:A8="E-Check",B2:B8,"")
Legacy Excel:
=IF(A2="E-Check",B2,"")
2 Replies
- Two ways to do it.
If you have SPILL capability:
=IF(A2:A8="E-Check",B2:B8,"")
Legacy Excel:
=IF(A2="E-Check",B2,"")- Excellent. Thank you and it does work.
Yok33
