Forum Discussion
Solved
Using OR in a formula
I need a formula to give 3 different answers based on the value of one cell in a worksheet that could change. J19 is the variable cell in my worksheet. The value of (J9-J20) may be a positive or neg...
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!!