Forum Discussion
Help with IF & AND with different outcomes for a Line of Credit Advances & Payments
Laurie-
I think this may be what you want in cell I27:
=IF(AND(H29>0,I26>1000,I26<H29,H30<$E$24),ROUNDDOWN(I26,0),IF(AND(H29>0,I26>1000,I26>=H29,H30<$E$24),ROUNDDOWN(H29,0)-3))
Can you give an example of where the formula doesn't work as expected? i.e. Add an extra row that shows the value that you expect to be returned. This way it will be easier to diagnose the issue.
Also what is the -3 intended to do?
Hi Matt, thank you for your reply. I did get this solved with this formula ( I had too many brackets and was telling it to be 0 in both cases, over thinking it!) . The -3 at the end is to rounddown to the nearest 1000.
=ROUNDDOWN(IF(AND(C29>0,D26>1000,D26<=C29,C30<$E$24),D26,IF(AND(C29>0,D26>1000,D26>=C29,C30<$E$24),C29,0)),0)
Glad you were able to resolve the issue! Nothing like that great feeling when the light bulb comes on and everything is as it should be in the world!!