Nestled IF Formula(s)

Rhonda Murray

I'm sure this is simple, but I can't seem to get it.

I'm trying to have the Partial Billed Dollars show in the AR column if Billed column contains a date. But once Paid column contains a date, I need that AR column to show Blank. This is done on the "child(ren)" level. I have a formula that SUMs the children.

I appreciate any help.

Thanks

Toufong Vang

Hi, Rhonda.

Try this...

=IF(AND(ISBLANK(Paid@row), NOT(ISBLANK(Billed@row)),[Partial Billed Dollars]@row),"")

Explanation...

You have 2 conditions for which you want the partial-billed dollars to show in the cell:

• When there is no date in Paid ISBLANK(Paid@row)
• When the customer has been billed NOT(ISBLANK(Billed@row))

IF( AND(Condition1, Condition2) , value_if_true, value_if_false )

Rhonda Murray

Returned

#INVALID DATA TYPE

Rhonda Murray

The below formulas work well individually within the cell. I need them nested properly.

=IF(NOT(ISBLANK(Billed@row)), [Partial Billed Dollars]@row)

=IF((ISBLANK(Paid@row)), [Partial Billed Dollars]@row)

Maybe this will help you move me in the right direction.

Thanks-

Rhonda