Microsoft Excel - rebate accrual - Asked By cliff black on 26-Sep-13 11:18 AM

How do you take 100k off of 4.9 million dollars and spread it out amongst 4k transactions all being different dollar amts.
Harry Boughen replied to cliff black on 26-Sep-13 04:21 PM
Hi Cliff,
I assume that you want it to be pro rata so you could try:
=ROUND(A1*0.989473684210526,2)
and copy down.
Regards
Harry
Pichart Y. replied to cliff black on 26-Sep-13 10:55 PM
Hi cliff black,

If you just want to format the way to see (display) the xx,xxx,xxx with xx mb. then use format cells > Custom >  in the "type" box input this format #,###,, "mb."

hope this help.

pichart Y.