IF Formula

[AMcBride]

I'm new here (my very first post), forgive me if I don't post correctly.

Example: =IF(H14<H13,H14-H13,H14=H13,0)
<h13,h14-h13,h14=h13,0)

I know there are too many arguments.</h13,h14-h13,h14=h13,0)>

Basically,I need to subtract H13-G14 and if that answer is the same as H13, then I want the cell left blank. If it changes then I want it to give me a new total. What I don't want is for the rest of column H to be the same number until it changes OR for there to be a row of $0.00.

 

[FDibbins]

=if(h13-g14=h13,"",h13-g14)

What I don't want is for the rest of column H to be the same number until it changes OR for there to be a row of $0.00.

No idea what that means??

 

[AMcBride]

Sorry for being so bad at putting this into words .. haha

When I put in the formula and then copy it all the way down for future use (I'm making a master sheet), it has the same number all the way down, when it changes they all change, until it changes again etc. I don't like the way it looks and it could be confusing to someone else trying to use it.

Also, do you know why the formula you gave me (thank you btw!) would be adding as I drag it down instead of subtracting?

 

[FDibbins]

I have no idea why a formula that says minus would be adding, unless the values it is applied to (G14?) are negative?

=if(and(h12=h13, g13=g14, h13-g14=h13),"",h13-g14)

 

[AMcBride]

Yes! They are negative numbers. The numbers in the H column are positive and G is negative.

 

[FDibbins]

OK so what do you expect as the outcome? neg - neg = pos...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr]
[tr][td]

19​

[/td][td]

5​

[/td][td]

-10​

[/td][td]

5​

[/td][/tr]

[tr][td]

20​

[/td][td]

10​

[/td][td]

-10​

[/td][td]

0​

[/td][/tr]

[tr][td]

21​

[/td][td]

15​

[/td][td]

-10​

[/td][td]

-5​

[/td][/tr]

[tr][td]

22​

[/td][td]

-5​

[/td][td]

-10​

[/td][td]

15​

[/td][/tr]

[tr][td]

23​

[/td][td]

-10​

[/td][td]

-10​

[/td][td]

20​

[/td][/tr]

[tr][td]

24​

[/td][td]

-15​

[/td][td]

-10​

[/td][td]

25​

[/td][/tr]
[/table]

C19=-A19-B19

 

[AMcBride]

Here's the idea. The sheet is for wage garnishments. So my starting figure is hingent on other formulas (they all work great). H is going to be their principal amount and G is what has been applied to the principal.

So H for example starts at $2,176.00 and every time I put in the amount that was applied to the principal in G it needs to keep deducting all the way down until the garnishment is paid off.

The reason it's not just a straightforward deduction is because out of say the $500 that was held, there are other fees that have to be paid first.

I hope this information helps

 

[FDibbins]

OK will this work for you?

[Table="width:, class:grid"][tr][td] [/td][td]

G​

[/td][td]

H​

[/td][/tr]
[tr][td]

2​

[/td][td][/td][td]

1176​

[/td][/tr]

[tr][td]

3​

[/td][td]

100​

[/td][td]

1076​

[/td][/tr]

[tr][td]

4​

[/td][td]

100​

[/td][td]

976​

[/td][/tr]

[tr][td]

5​

[/td][td]

100​

[/td][td]

876​

[/td][/tr]

[tr][td]

6​

[/td][td]

100​

[/td][td]

776​

[/td][/tr]

[tr][td]

7​

[/td][td]

100​

[/td][td]

676​

[/td][/tr]

[tr][td]

8​

[/td][td]

100​

[/td][td]

576​

[/td][/tr]

[tr][td]

9​

[/td][td]

100​

[/td][td]

476​

[/td][/tr]

[tr][td]

10​

[/td][td]

100​

[/td][td]

376​

[/td][/tr]

[tr][td]

11​

[/td][td]

100​

[/td][td]

276​

[/td][/tr]

[tr][td]

12​

[/td][td]

100​

[/td][td]

176​

[/td][/tr]

[tr][td]

13​

[/td][td]

100​

[/td][td]

76​

[/td][/tr]

[tr][td]

14​

[/td][td]

100​

[/td][td]

0​

[/td][/tr]

[tr][td]

15​

[/td][td]

100​

[/td][td]

0​

[/td][/tr]

[tr][td]

16​

[/td][td]

100​

[/td][td]

0​

[/td][/tr]

[tr][td]

17​

[/td][td]

100​

[/td][td]

0​

[/td][/tr]
[/table]
H2=starting value
H3=IF(H2-G3<0,0,H2-G3)
copied down

 

[AMcBride]

Thank youuu!

 

[FDibbins]

Happy to help