Need to add extra amount in my formula so it can give correct info

**hendrikbez** · 09-02-2021, 09:50 AM

I have this formula

Please Login or Register  to view this content.

I am trying to add and extra amount that is in R13 [SERVICE FEE] to this formula, but can not get it to work

**JohnTopley** · 09-02-2021, 09:58 AM

There are instructions at the top of the page explaining how to attach your sample workbook.

**hendrikbez** · 09-02-2021, 10:10 AM

Here is the file

Password crypto@12

**JohnTopley** · 09-02-2021, 11:00 AM

Is the Service Fee to be added to all TXs:

This ?????

=IF(Leening!$B13<>"",IF(ROW()-ROW(Leening!$D$11)=1,LoanAmount+R13,INDEX(Leening!$J$12:$J$371,ROW()-ROW(Leening!$D$11)-1))+R13,"")

**hendrikbez** · 09-02-2021, 11:04 AM

Thank you, i only did put it in the end like you did, not befroe index

Need to add extra amount in my formula so it can give correct info

LinkBack

Thread Tools

Rate This Thread

Display

Need to add extra amount in my formula so it can give correct info

Re: Need to add extra amount in my formula so it can give correct info

Re: Need to add extra amount in my formula so it can give correct info

Re: Need to add extra amount in my formula so it can give correct info

Re: Need to add extra amount in my formula so it can give correct info

Thread Information

Users Browsing this Thread

Similar Threads

SUMIF or any formula that will give correct recap amounts

Adding extra items to a formula for correct email syntax

Formula to give me an amount from a percentage

Need help - Formula to Find and give the total amount of Text.

LOOKUP does not always give the correct result - correct number of vectors etc checked

[SOLVED] Formula to give An amount with 10% adding

Excel 2007 : Formula does not give correct Total.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions