I decided to merge 2 columns on my budget spreadsheet and it works, but I am wanting to make an adjustment. My eyes are playing tricks on me though so I'm asking for some help please.
I merged this "minimum payment" column...
=IF($D4<25,$D4,IF($D4*2%<25,25,IF($D4*2%>25,$D4*2%)))
and this "actual payment" column...
=VLOOKUP(C4,'Personal Budget'!$A$4:$M$157,MONTH(TODAY())+1,0)
to make this "payment" column...
=IF($D4<25,$D4,VLOOKUP($C4,'Personal Budget'!$A$4:$M$157,MONTH(TODAY())+1,0))
It works!
What I want to add is that if the vlookup formula finds $C4 = 0, then $D4*2%
I'm pretty sure that I need to just surround the vlookup formula with an IF statement, I just can't get the () right or something. Please advise.
Ultimately, if my balance amount (D4) is less than $25 but greater than 0, then display D4, otherwise if C4 from Personal Budget sheet is 0, then display D4*2%, otherwise display C4 from Personal Budget sheet.
Hope that makes sense, another way of putting it... if, when it searches C4 it find 0, then display D4*2%.
Maybe these need to be put in a different order?
I merged this "minimum payment" column...
=IF($D4<25,$D4,IF($D4*2%<25,25,IF($D4*2%>25,$D4*2%)))
and this "actual payment" column...
=VLOOKUP(C4,'Personal Budget'!$A$4:$M$157,MONTH(TODAY())+1,0)
to make this "payment" column...
=IF($D4<25,$D4,VLOOKUP($C4,'Personal Budget'!$A$4:$M$157,MONTH(TODAY())+1,0))
It works!
What I want to add is that if the vlookup formula finds $C4 = 0, then $D4*2%
I'm pretty sure that I need to just surround the vlookup formula with an IF statement, I just can't get the () right or something. Please advise.
Ultimately, if my balance amount (D4) is less than $25 but greater than 0, then display D4, otherwise if C4 from Personal Budget sheet is 0, then display D4*2%, otherwise display C4 from Personal Budget sheet.
Hope that makes sense, another way of putting it... if, when it searches C4 it find 0, then display D4*2%.
Maybe these need to be put in a different order?