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
 1st, 2nd, 3rd position formula in excel ✓  Office Software Forum
 Number to words in excel formula  Guide
 Little alchemy formulas  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Excel formula if cell contains text then return value in another cell ✓  Excel Forum
1 reply
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