Microsoft Office Forums - View Single Post - Revenue Recognition Schedule formula problem

Thread: Revenue Recognition Schedule formula problem

View Single Post

Old

05-23-2018, 08:07 AM

Roger Govier Roger Govier is offline

Roger Govier is offline

Roger Govier uses Windows 10

Windows 10 Roger Govier uses Office 2016

Roger Govier uses Office 2016

Office 2016

Novice

Join Date: Oct 2017

Location: Abergavenny, Wales, UK

Posts: 13

Roger Govier is on a distinguished road

Default

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))

Reply With Quote