Asset Write off calculation Automation

0 votes

How do I show all the write-off values in the year of the write-off?

I have the below model were in: The formula in cell(O,29) is =

-SUM(OFFSET(O14,,,1,-MIN($G$20,P$3))/$G$20)+IF(O23=1,0,SUM(OFFSET(O14,,,1,-MIN($G$20,P$3))/$G$20)).

This gives me the flag-year depreciation but I wanted all the remaining depreciation so it should be $120.

enter image description here

Feb 14, 2023 in Others by narikkadan
• 63,680 points
286 views

1 answer to this question.

0 votes

How about this in O29:

=LET(period,     5,
     value,      I14:W14,
     flag,       I23:W23,
     startvalue, FILTER(value,value<>""),
     start,      FILTER(COLUMN(value),value<>""),
     writtenoff, startvalue/period*(COLUMN()-start),
IF(O23="",
   "",
   startvalue-writtenoff))

If you would drag this down/left/right, this would also take into account the 2 values for the convertor belts, for instance.

answered Feb 14, 2023 by Kithuzzz
• 38,020 points

Related Questions In Others

0 votes
0 answers

how to list the contents of a asset into an event

May 29, 2019 in Others by anonymous
645 views
0 votes
0 answers

Can we write AES enryption in Javascript and Decryption in Java using a static SALT and IV

I'm working on AES encryption I want to ...READ MORE

Jun 4, 2019 in Others by Eighteen
• 120 points
1,878 views
0 votes
0 answers

Write a DAX query to obtain the bottom 5 customers based on the order price

Jan 22, 2020 in Others by anonymous
• 170 points
419 views
0 votes
0 answers
0 votes
0 answers

DynamoDB Transactional Write on Global Tables With DB Streams

How does DynamoDB handle TransactionalWrite on the ...READ MORE

Apr 5, 2022 in Others by Kichu
• 19,040 points
452 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
3,873 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,962 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
958 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,608 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP