Unlike a basic IF statement, I need Excel to calculate one formula if a designated cell is blank but a slightly different formula if the designated cell has a value higher than 0.
If an existing employee has monthly base pay, commission, overtime, and shift differential which need to be added to obtain gross pay – no problem, simple addition.
However, I need to add a column next to monthly base pay for any new employees' monthly pro-rated pay amount. I need Excel to look to see if there is a value in the pro-rated pay column first. If yes, I need it to add pro-rated pay + commission + overtime + shift differential to compute gross pay. If the pro-rated pay column is blank, I need it to add full monthly pay + commission + overtime + shift differential to calculate gross pay.
To clarify: if the pro-rated pay is not blank, I want the sum to exclude the full monthly pay.