Trouble with IF Statement

Jenn Morabito

I am trying to incorporate two functioning formulas into one.

The formula I was using and works is:

=(([Cost based on Rate] @row - [Deductible Remaining] @row) * [Co-ins% or Co-pay$]@row) + [Deductible Remaining] @row

However, that doesn't account for if the Co-insurance% or Co-pay$ field is blank. So I made this formula that works:

=IF(ISBLANK([Co-ins% or Co-pay$]@row), [Cost based on Rate] @row - [Deductible Remaining] @row, "false")

I combined them this way but it's not working:

=IF(ISBLANK([Co-ins% or Co-pay$]@row), [Cost based on Rate] @row - [Deductible Remaining] @row, (([Cost based on Rate] @row - [Deductible Remaining] @row) * [Co-ins% or Co-pay$]@row) + [Deductible Remaining] @row)

Any help is appreciated!

RossL

@Jenn Morabito

This worked for me when I recreated it.

=IF(ISBLANK([Co-ins% or Co-pay$]@row), [Cost Based on Rate]@row - [Deductible Remaining]@row, (([Cost Based on Rate]@row - [Deductible Remaining]@row) * [Co-ins% or Co-pay$]@row) + [Deductible Remaining]@row)

it looks like there were spaces between the column name and @row that might have been the issue.

RossL

@Jenn Morabito

This worked for me when I recreated it.

=IF(ISBLANK([Co-ins% or Co-pay$]@row), [Cost Based on Rate]@row - [Deductible Remaining]@row, (([Cost Based on Rate]@row - [Deductible Remaining]@row) * [Co-ins% or Co-pay$]@row) + [Deductible Remaining]@row)

it looks like there were spaces between the column name and @row that might have been the issue.

Jenn Morabito

@RossL Thank you! I knew I was close!