Related:

- Text if/then formula to use seperate formulas
- Spreadsheet formula - Articles
- Excel @ in formula ✓ - Forum - Excel
- 1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
- How to copy data from one sheet to another in excel using formula - How-To - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel

## 1 reply

ExcelJosh

- Posts
- 12
- Registration date
- Wednesday August 8, 2012
- Status
- Contributor
- Last seen
- October 12, 2012

=IF(A1="AS",$B$1,IF(A1="BS",$B$2,IF(A1="GS",$B$3,IF(A1="HG",$B$4))))

Replace the "AS","BS","GS", "HG" with the initials of the employees.

Replace the $B$1, $B$2, $B$3, $B$4 with the formulas.

The IF formula is =IF(logic, [if true], [if false]), so I created a nested IF formula.

Let me know if this makes sense or if you have questions.

Good luck,

Josh

Replace the "AS","BS","GS", "HG" with the initials of the employees.

Replace the $B$1, $B$2, $B$3, $B$4 with the formulas.

The IF formula is =IF(logic, [if true], [if false]), so I created a nested IF formula.

Let me know if this makes sense or if you have questions.

Good luck,

Josh

Report

amilcaranastasia

Thank you Josh. That worked perfectly, you just made my life easier and my boss happier!