Revenue Recognition Schedule formula problem

Roger Govier · #1 05-23-2018, 08:07 AM

Hi

I just edited the formula in cell BO 10 and copied it across and It think it does what you require

=IF(SUM($AH10:BN10)=$Z10,0,IF(DAYS360($D10,BO$1)>1 ,$Z10/$S10*INT(DAYS360($C10,BO$1)/30)-SUM($AH10:BN10),0))

esimmonds · #2 05-24-2018, 09:02 AM

Roger,

Like the formula however it doesn't work, please see attachment.

Thoughts?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing schedule into another schedule and keeping the links	abby1428	Project	0	03-16-2018 04:21 PM
Deferred Revenue Amortisation Formula help	Haha88	Excel	8	01-08-2018 02:00 PM
I am asking some formula for electrical panel schedule	james64	Excel	2	01-16-2016 09:23 PM
Revenue REcognition for Leasing business	sshetty	Excel Programming	1	05-11-2015 01:42 AM
Excel Formula Showing Revenue Recognition Based on Days and Months	stratcat	Excel	4	03-16-2014 10:09 AM