So I am trying to write a formula for a bigger project I am working on, and I am running into a problem. I want to have this formula subtract dues from a member's current credit balance. But my IF Statement is giving me a false result. Any help is greatly appreciated!
m9SReJF.png
Here is my formula:Formula:=IF(A2<B8,MAX(0,A2,IF(A2>B8,MIN(B8,A2))))
Bookmarks