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 negative number and then I need a value in J21 based on positive or negative.  If positive, I need the sum.  If negative, I need the cell to be 0.

If J20 is zero I need the value to be the sum of another cell J23

These are the 3 formulas that will give the correct answers but I need it to be an OR to each formula to get the correct answer in cell J25

J25

=IF(J20>J9,J9,J9-J20)+J22+J23+E18 works if the deductible is LARGE

=IF(J20>J9,J9,J9-J20)+J22+J23+E18 works if the deductible is smaller than the charges

=IF(j20=0,J23)+E18 works if the deductible is zero and there is a copay

Is this even possible to solve for?

Thank you,

Donna

​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 negative number and then I need a value in J21 based on positive or negative.  If positive, I need the sum.  If negative, I need the cell to be 0.If J20 is zero I need the value to be the sum of another cell J23 These are the 3 formulas that will give the correct answers but I need it to be an OR to each formula to get the correct answer in cell J25J25=IF(J20>J9,J9,J9-J20)+J22+J23+E18 works if the deductible is LARGE=IF(J20>J9,J9,J9-J20)+J22+J23+E18 works if the deductible is smaller than the charges=IF(j20=0,J23)+E18 works if the deductible is zero and there is a copay Is this even possible to solve for?Thank you,Donna   Read More

​