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.