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
 Date formula in excel dd/mm/yyyy  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Number to words in excel formula  Guide
 Excel grade formula  Guide
 Little alchemy formulas  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