I have a multiple IF statement, and it works quite well. But I am trying to "upgrade" it. I added an additional column to my worksheet. The current formula which works fine is:

=IF(NOT(ISBLANK(O198)),"PAID",IF(AND(ISNUMBER(D198),D198>30),TODAY()-D198,"Incomplete"))

but now I have Column C, which is a "status". The formula above is in cell V198. Column O is where the payment date is recorded. Column O is left blank until payment is received. Now in cell C198, there can be any of the following options (from a pulldown list):

Cancelled

Completed

Hold

Pending

Printed

Scheduled

Now in addition to what the current formula does, I also want it to allow the following.

If the value in Column C is then Column V would display

Cancelled Cancelled

Completed *use formula to determine if payment received in Column O.

Hold Incomplete

Pending Incomplete

Printed Incomplete

Scheduled Incomplete

(Blank) (Blank)

If payment has been received (payment date recordered in Column O, then PAID is the value shown in Column V (where this formula is). If there is no data in Column O AND Column C shows Completed and Column D shows a completion date, then the number of days between today and the completion date (Column D) is displayed. Otherwise, this cell shows Incomplete.

Does this make sense? I am not that famiar with the "NOT" function, and the ISNumber function. So as a result, I am having difficulty determining exactly how to incorporate this new set of criteria into my current formula. I have spent over 1 hour working on this, and I am no closer to figuring it out.

=IF(NOT(ISBLANK(O198)),"PAID",IF(AND(ISNUMBER(D198),D198>30),TODAY()-D198,"Incomplete"))

but now I have Column C, which is a "status". The formula above is in cell V198. Column O is where the payment date is recorded. Column O is left blank until payment is received. Now in cell C198, there can be any of the following options (from a pulldown list):

Cancelled

Completed

Hold

Pending

Printed

Scheduled

Now in addition to what the current formula does, I also want it to allow the following.

If the value in Column C is then Column V would display

Cancelled Cancelled

Completed *use formula to determine if payment received in Column O.

Hold Incomplete

Pending Incomplete

Printed Incomplete

Scheduled Incomplete

(Blank) (Blank)

If payment has been received (payment date recordered in Column O, then PAID is the value shown in Column V (where this formula is). If there is no data in Column O AND Column C shows Completed and Column D shows a completion date, then the number of days between today and the completion date (Column D) is displayed. Otherwise, this cell shows Incomplete.

Does this make sense? I am not that famiar with the "NOT" function, and the ISNumber function. So as a result, I am having difficulty determining exactly how to incorporate this new set of criteria into my current formula. I have spent over 1 hour working on this, and I am no closer to figuring it out.

## Comment