ashwithonline
Member
Hi Team,
In the sheet attached, i am trying to calculate the revenue for a person i.e., rate * 8 * actual working days
In D2 of summary i added an if formula with the grade cell reference and multiplied it by 8 - it threw a error
In E2 the formula is the earlier version without cell reference, but i needed the cell reference as the rates are bound to change every quarter
The G column of the days spreadsheet is the the actual working days.
Can anybody please help me with this formula.
Regards,
Jagdish
In the sheet attached, i am trying to calculate the revenue for a person i.e., rate * 8 * actual working days
In D2 of summary i added an if formula with the grade cell reference and multiplied it by 8 - it threw a error
In E2 the formula is the earlier version without cell reference, but i needed the cell reference as the rates are bound to change every quarter
The G column of the days spreadsheet is the the actual working days.
Can anybody please help me with this formula.
Regards,
Jagdish