S Smith Onyema New Member Feb 18, 2015 #1 Please i need help in creating my payroll, the question is attached Attachments PAYROLL QUESTION.xlsx PAYROLL QUESTION.xlsx 9.9 KB · Views: 11
Luke M Excel Ninja Staff member Feb 18, 2015 #2 Hi Smith, and welcome to the forum I'm afraid that you're going to need to provide more information. I have no idea what any of these numbers mean, or what you're trying to do with the formula:
Hi Smith, and welcome to the forum I'm afraid that you're going to need to provide more information. I have no idea what any of these numbers mean, or what you're trying to do with the formula:
Hui Excel Ninja Staff member Feb 19, 2015 #3 I think D4 should be: =IF(AND(A4=8,B4=10),127301,IF(AND(A4=8,B4=9),125881,0)) Copy D4 Down But I'm not sure if that should be in D4 or C4?
I think D4 should be: =IF(AND(A4=8,B4=10),127301,IF(AND(A4=8,B4=9),125881,0)) Copy D4 Down But I'm not sure if that should be in D4 or C4?
