Forum Discussion
Help with IF & AND with different outcomes for a Line of Credit Advances & Payments
Hello Excel Formula Experts!
This is my first time here so I hope I have posted all the correct info &file
I’m need of help with this formula:
=ROUNDDOWN(IF(AND(H29>0,I26>1000,I26<=H29,H30<$E$2...
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!!