Forum Discussion
Using OR in a formula
Hi,
Thank you for sharing a sample document. Try using this on the estimated patient balance (J25 cell):
=IFS(J20>J9,J9+J22+J23+E18,J20<J9,J20+J22+J23+E18,J20=0,J23+E18)
Does this unique formulation calculate each scenario correctly independently on the case?
Martin
Hello,
Can you attach a sample file or a screenshot without sensitive data? It would be much easier to follow your explanation.
When you say: "If positive, I need the sum". The sum of which cells?
Also, what are the other cells in your formulation? (J22, E18...) =IF(J20>J9,J9,J9-J20)+J22+J23+E18
Thank you for your response. I am attaching the link for the file for your review.
https://1drv.ms/x/c/781d73810532bd92/EfQ3nO52MGtOiDsa1UBItfYB9CkPshFumoZcP3xd5mEKXQ?e=mGUbdU&nav=MTVfe0Y1MjhGMzE5LTNGQUQtNDZGNS1CMDA0LTY5QjM4QUJEQjhBOH0
I hope this helps. I am trying to calculate the patient responsibility after insurance is applied, with deductible that is less than the Insurance charged amount, more than and with no deductible and only a copay.
Thank you!
Hi,
Thank you for sharing a sample document. Try using this on the estimated patient balance (J25 cell):
=IFS(J20>J9,J9+J22+J23+E18,J20<J9,J20+J22+J23+E18,J20=0,J23+E18)
Does this unique formulation calculate each scenario correctly independently on the case?
Martin
- AWESOME!!! Thank you so very much for your assistance!!