SOLVED
Home

Percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-716194%22%20slang%3D%22en-US%22%3EPercentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716194%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20out%20balances%20on%20debt%20owed%20and%20payments%20made.%20This%20is%20my%20formula%20I%20use%20to%20calculate%20the%20interest%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D(G8*C6%2F100)%2F365*D8%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EG8%20is%20the%20capital%20amount%20due%3C%2FP%3E%3CP%3EC6%20is%20the%20percentage%3C%2FP%3E%3CP%3ED8%20is%20the%20total%20days%20between%20payments%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20on%20my%20next%20line%20(row%209)%20in%20want%20to%20tell%20it%20that%20if%20G9%20is%20greater%20than%20G8%20the%20formula%20must%20read%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D(G8*C6%2F100)%2F365*D9%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eif%20G9%20is%20less%20than%20G8%20the%20formula%20must%20be%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D(G9*C6%2F100)%2F365*D9%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESee%20attached%20spreadsheet%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-716194%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716232%22%20slang%3D%22en-US%22%3ERe%3A%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716232%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365429%22%20target%3D%22_blank%22%3E%40Welda1962%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20guess%20you%20need%20to%20direct%20your%20calculation%20to%20one%20of%202%20options%20based%20on%20a%20comparison%20between%202%20values%20G8%20%26amp%3B%20G9%3C%2FP%3E%3CP%3EAccordingly%2C%20it%20should%20be%20a%20simple%20IF%20statement%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(G9%26gt%3BG8%2C%26nbsp%3B(G8*C6%2F100)%2F365*D9%2C%26nbsp%3B(G9*C6%2F100)%2F365*D9)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIf%20copying%20your%20formulas%20down%20then%20you%20have%20to%20mind%20Relative%20%26amp%3B%20Absolute%20cell%20references.%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716781%22%20slang%3D%22en-US%22%3ERe%3A%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365429%22%20target%3D%22_blank%22%3E%40Welda1962%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20consistency%20of%20formulas%20along%20rows%2C%20I%20suggest%20this%20formula%20in%20H8%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(G8%26gt%3BG7%2CG7%2CG8)*%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EC%246%2F100*%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3ED8%2F365%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ESee%20such%20formula%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Welda1962
Occasional Visitor

I work out balances on debt owed and payments made. This is my formula I use to calculate the interest:

=(G8*C6/100)/365*D8

G8 is the capital amount due

C6 is the percentage

D8 is the total days between payments

 

Now on my next line (row 9) in want to tell it that if G9 is greater than G8 the formula must read:

=(G8*C6/100)/365*D9

if G9 is less than G8 the formula must be:

=(G9*C6/100)/365*D9

 

See attached spreadsheet

 

2 Replies

@Welda1962 

Hi

I guess you need to direct your calculation to one of 2 options based on a comparison between 2 values G8 & G9

Accordingly, it should be a simple IF statement like this:

=IF(G9>G8, (G8*C6/100)/365*D9, (G9*C6/100)/365*D9)

If copying your formulas down then you have to mind Relative & Absolute cell references.

Hope that helps

Nabil Mourad

Solution

@Welda1962 

For consistency of formulas along rows, I suggest this formula in H8: 

=IF(G8>G7,G7,G8)*
C$6/100*
D8/365

See such formula in the attached file.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies