added all the formulas for bonus ,car allowances,medical...but adding all car cost, medical are showing zeros
@Nehal1511
When you observe the formula that you have written, the first condition of if-else statement is false, that is why the Medical Costs are coming Zero.
~Anand
can you please give me little hint to where i have to make changes
Would you not mind sharing the logic that you have applied in calculating the car costs and medical costs. Also select any Employee from the drop down list to check the values and not the departments.
still not working after taking the employee
Can we get a follow up on this?
We have a question regarding the behavior of the XL3dowriteback formula. Our understanding is that this formula allows writeback to be controlled on a cell-by-cell basis. In our operation, when we need to clear a previously written-back value due to an input error or similar reason, we do so by entering 0. However, when…
Facing challange to get the exact totals for Q1 Q2 line items(it should be 21250), Can somebody please suggest a way to get subtotals intead of grand totals. My Summary should be dynamic.
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
