Text if/then formula to use seperate formulas
Solved/Closed
amilcaranastasia
Posts
1
Registration date
Wednesday 5 September 2012
Status
Member
Last seen
5 September 2012
-
5 Sep 2012 à 12:18
amilcaranastasia - 6 Sep 2012 à 11:17
amilcaranastasia - 6 Sep 2012 à 11:17
Related:
- Text if/then formula to use seperate formulas
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Little alchemy formulas - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
1 response
ExcelJosh
Posts
12
Registration date
Wednesday 8 August 2012
Status
Contributor
Last seen
12 October 2012
5 Sep 2012 à 13:53
5 Sep 2012 à 13:53
=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
6 Sep 2012 à 11:17