any formula to auto calculate 1st-12th is 12 days pls?
Dear Excel users,
Could you please help me with which formula can be used for either:
First column we key in "1st - 12th" and the next column will auto calculate
"12 days" x $284 (this amount is not fix so we need to manually key in) and
finally the last column will auto calculate "3408"
OR
First column we key in "person's name (1st-12th)", next column auto
calculate "12 days", next column we key in $284, last column auto calculate
"3408"
I hope you understand what i mean, and can assist me.
Thank you.
Regards,
Kelly
|