Text if/then formula to use seperate formulas
Solved/Closed
amilcaranastasia
Posts
2
Registration date
Wednesday September 5, 2012
Status
Member
Last seen
September 5, 2012
-
Sep 5, 2012 at 12:18 PM
amilcaranastasia - Sep 6, 2012 at 11:17 AM
amilcaranastasia - Sep 6, 2012 at 11:17 AM
Related:
- Text if/then formula to use seperate formulas
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
ExcelJosh
Posts
12
Registration date
Wednesday August 8, 2012
Status
Contributor
Last seen
October 12, 2012
Sep 5, 2012 at 01:53 PM
Sep 5, 2012 at 01:53 PM
=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
Sep 6, 2012 at 11:17 AM