Hi All,
I'm attempting to create an if statement in order to figure out some prorations. I do not think my formula is calculating the date as the date. Right now it's:
=IF(B2=2/1/2019,(ROUNDUP(1000*11/12,2)),IF(B2=3/1/2019,(ROUNDUP(1000*10/12,2)),IF(B2=1/1/2019,(ROUNDUP(1000*12/12,2)),"")))
I don't think I'm trying to do anything terribly complicated - just prorate based on month, so if the date in column B is 2/1/2019, then I want 1000 prorated to equal 916.xx.
I've tried several things, but none of them have been successful.
Can someone help?
Bookmarks