nesting formulas, if a4=1 than d4=b4*c4

[nan811]

i'm trying to create a spreadsheet for payroll. I get the employees
paycodes downloaded into excel with their payrates.
I'm trying to create a column for each paycode to calculate the
earnings. This spreadsheet will help each payperiod to compare to
Ceridians payroll reports for balancing to what was entered as
timecards and what document changes were made.
The formulas should be:

first column If column a = 1 than d should equal b times c.
second column If column a = 2 than d should equal b4 times c

and so one to create the paid amount for each paycode.

do you understand?

Thanks!!

 

[Niek Otten]

<first column If column a = 1 than d should equal b times c.
second column If column a = 2 than d should equal b4 times c

and so one to create the paid amount for each paycode.>

<do you understand?>

No. What is first column, second column, column a, b, b4, c?

Please try to be more precise. Don't hesitate to post again!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel